SCC_CAF_RAT_CTX

(SQL Table)
 Index Back

Record Attributes Header

  • Parent record: SCC_CAF_RATRHDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDDB

    4 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

    Prompt Table: SCC_CAF_LBL_VW

    5 SCC_CAF_USESHORTNM Character(1) VARCHAR2(1) NOT NULL Use Short Label

    Y/N Table Edit

    Default Value: N

    6 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: SCC_CAF_REC_VW

    7 FIELDNAME0 Character(18) VARCHAR2(18) NOT NULL Name of Field

    Prompt Table: SCC_CAF_RFLD_VW

    8 SCC_CAF_SHOWREL Character(1) VARCHAR2(1) NOT NULL Show Only Description

    Y/N Table Edit

    Default Value: N

    9 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N

    10 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    11 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    12 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    13 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time