GVT_SF50_RK_TBL(SQL Table) |
Index Back |
---|---|
SF50/52 Remarks Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GVT_SF50_REMARK | Character(3) | VARCHAR2(3) NOT NULL | SF50 Remark Code |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | PRINT_PRIORITY | Character(2) | VARCHAR2(2) NOT NULL |
Used to decide the priority in which the Remarks are printed on the SF50 Report.
01=1st Tier 02=2nd Tier Default Value: 01 |
5 | GVT_REMARK_LINE1 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 1 |
6 | GVT_REMARK_LINE2 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 2 |
7 | GVT_REMARK_LINE3 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 3 |
8 | GVT_REMARK_LINE4 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 4 |
9 | GVT_REMARK_LINE5 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 5 |
10 | GVT_REMARK_LINE6 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 6 |
11 | GVT_REMARK_LINE7 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 7 |
12 | GVT_REMARK_LINE8 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 8 |
13 | GVT_REMARK_LINE9 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 9 |
14 | GVT_INSERT_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Insertion Required
Y/N Table Edit Default Value: N |
15 | GVT_IRR_REPORTABLE | Character(1) | VARCHAR2(1) NOT NULL |
IRR Reporting Settings
Y/N Table Edit Default Value: N |
16 | GVT_ROST_REMARK | Character(1) | VARCHAR2(1) NOT NULL |
ROST Reportable
Y/N Table Edit Default Value: N |