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 NameField TypeColumn TypeDescription
PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).

Prompt Table: PSADSDEFN
Set Control Field: PTADSNAME

FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: PSDBFIELD_VW

RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN_VW

FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
DEFRECNAMECharacter(15)VARCHAR2(15) NOT NULLDefault Record Name
DEFFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLDefault Field Name
EDITTABLECharacter(15)VARCHAR2(15) NOT NULLEdit Table
USEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags- USEEDIT reference
USEEDIT2Number(10,0)DECIMAL(10) NOT NULLMore Field Use and Edit Flags
SUBRECORDCharacter(1)VARCHAR2(1) NOT NULLSub Record
SUBRECVERNumber(10,0)DECIMAL(10) NOT NULLSub Record Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19