PTADSRECFLD_VW

index back

ADS Record Field View


SELECT i.ptadsname , a.fieldname , a.recname , a.fieldnum , a.defrecname , a.deffieldname , a.edittable , a.useedit , a.useedit2 , a.subrecord , a.subrecver FROM psadsdefnitem i , psrecfielddb a WHERE i.recname = a.recname AND i.ptparentrecname = ' '

PeopleSoft Field Name Field Type Column Type Description
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

Prompt Table: PSADSDEFN
Set Control Field: PTADSNAME

FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD_VW

RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN_VW

FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
DEFRECNAME Character(15) VARCHAR2(15) NOT NULL Default Record Name
DEFFIELDNAME Character(18) VARCHAR2(18) NOT NULL Default Field Name
EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
USEEDIT2 Number(10,0) DECIMAL(10) NOT NULL More Field Use and Edit Flags
SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
SUBRECVER Number(10,0) DECIMAL(10) NOT NULL Sub Record Version
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19