GVT_IRR_REMARKPrompt Table: GVT_IRR_RK_TBL
EFFDTDefault Value: %date
SEQ_NODefault Value: 10
E=Employee level specified
T=Text
D=Date
N=Number
T=Text
GVT_IRR_RK_FMT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_IRR_REMARK |
Character(3) | VARCHAR2(3) NOT NULL |
IRR Remark Code
Prompt Table: GVT_IRR_RK_TBL |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 10 |
| 4 | GVT_IRR_RK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
IRR Remark Type
E=Employee level specified T=Text |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | GVT_RMK_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
IRR Remark Field Type
D=Date N=Number T=Text |
| 8 | GVT_RMK_VAL_TEXT | Character(30) | VARCHAR2(30) NOT NULL | Remark - Text Val |
| 9 | GVT_RMK_LBL | Character(25) | VARCHAR2(25) NOT NULL | Remark Label |