PSPTDBFLDLABL_V

index back

Record Field Labels

Used for Definition Security.
SELECT A.RECNAME ,A.FIELDNAME ,A.FIELDNUM ,(CASE WHEN %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT AND A.FIELDNAME NOT IN ('EFFDT' ,'MARKET') THEN 'Key' WHEN %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT AND A.FIELDNAME IN ('EFFDT' ,'MARKET') THEN 'Ignore' ELSE ' ' END) ,B.LONGNAME ,B.SHORTNAME FROM %Table(PSRECFIELDDB) A , %Table(PSDBFLDLABL) B WHERE A.FIELDNAME = B.FIELDNAME AND ((A.LABEL_ID <> ' ' AND A.LABEL_ID = B.LABEL_ID) OR (A.LABEL_ID = ' ' AND B.DEFAULT_LABEL = 1))

  • Related language record: PSPTDBFLDLABLLV
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
    FIELDDESCRCharacter(20)VARCHAR2(20) NOT NULLDescription
    LONGNAMECharacter(30)VARCHAR2(30) NOT NULLLong Name
    SHORTNAMECharacter(15)VARCHAR2(15) NOT NULLField Short Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19