RA_REC1FLD1_VW

(SQL View)
 Index Back

Record Field

Record fields including sub record fields and field descriptions

SELECT RECNAME , FIELDNAME , FIELDNUM , DESCR , LABEL_ID , LONGNAME , SHORTNAME , FIELDTYPE , LENGTH , DECIMALPOS FROM PS_RA_RECFIELD_VW

  • Related Language Record: RA_RFLD1_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: PSRECDEFN

    2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: PSDBFIELD

    3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    6 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    7 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    9 LENGTH Number(5,0) INTEGER NOT NULL Length
    10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions