SETIDDefault Value: OPR_DEF_TBL_RB.SETID
MOD_TYPE_IDA=Active
I=Inactive
RB_MOD_TYPE_VW(SQL View) |
Index Back |
|---|---|
AAF Modification TypesRecord is used for retrieving modification types used by AAF term |
| SELECT setid , mod_type_id , short_descr , long_desc , status , hist_count_func , config_count_func FROM PS_RB_MOD_TYPE_DFN |
| # | 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 |
| 2 | MOD_TYPE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Modification Type ID |
| 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 |