SCC_CAF_RATRHDR(SQL Table) |
Index Back |
---|---|
Record Attributes |
# | 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 |