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 Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    FIELDDESCR Character(20) VARCHAR2(20) NOT NULL Description
    LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19