SCC_CAF_RATRHDR

(SQL Table)
Index Back

Record Attributes

  • Related Language Record: SCC_CAF_RAHDRLN
  • Parent Record Of SAD_CA_APCFB_VW SAD_CA_APCFN_VW SAD_CA_APCFT_VW SCC_CAF_RAT_CTX SCC_CAF_RAT_ENT SCC_CAF_RECATTR SSR_BR_APTATRLN SSR_BR_APTATRVW SSR_BR_ATRNM_VW SSR_BR_IDOK_VW SSR_BR_PECF_VW SSR_BR_PLLV_VW SSR_RI_DPLVA_VW SSR_RI_DPTAT_VW SSR_RI_EDLOCLVW SSR_RI_EPCDS_VW SSR_RI_LCLVA_VW SSR_RI_OLCDS_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    2 SCC_CAF_RECNAME Character(15) VARCHAR2(15) NOT NULL Attribute Record

    Prompt Table: SCC_CAF_SBR_VW

    3 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_CAF_AENT_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SCC_CAF_PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name

    Prompt Table: SCC_CAF_SEC_PGS

    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Default Value: 14097

    Prompt Table: PSMSGSETDEFN

    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Default Value: 36

    Prompt Table: PSMSGCATDEFN

    8 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

    Prompt Table: SCC_APPCLASS_PT

    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_CAF_DISP_TYPE Character(3) VARCHAR2(3) NOT NULL Attribute Display Type
    001=Inline Subpage
    002=Secondary Page
    11 SCC_CAF_EXTND_STG Character(1) VARCHAR2(1) NOT NULL Extend to staging record

    Y/N Table Edit

    Default Value: N

    12 SCC_STG_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: PSRECDEFN

    13 SCC_CAF_STGRECNAME Character(15) VARCHAR2(15) NOT NULL Staging Attribute Record

    Prompt Table: SCC_CAF_SBR_VW

    14 SCC_CAF_EDITTABLE Character(15) VARCHAR2(15) NOT NULL Override Prompt Table

    Prompt Table: PSRECDEFN

    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time