SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
MOD_TYPE_IDDefault Value: NEXT
A=Active
I=Inactive
RB_MOD_TYPE_DFN(SQL Table) |
Index Back |
|---|---|
AAF Modification TypesRecord is used for storing modification types used by AAF term |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | MOD_TYPE_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Field used for storing Modification Type ID
Default Value: NEXT |
| 3 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |
| 4 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 6 | HIST_COUNT_FUNC | Number(31,0) | DECIMAL(31) NOT NULL | Field used for storing Hirical Count Function |
| 7 | CONFIG_COUNT_FUNC | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Configuration Count Function |