GVT_ACR_ADJ_LNG(SQL Table) |
Index Back |
---|---|
Accrual AdjustmentsRelated Language record for GVT_ACCR_ADJ. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
3 | Character(6) | VARCHAR2(6) NOT NULL | Earnings Accrual Class | |
4 | Date(10) | DATE NOT NULL | Effective Date | |
5 | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code | |
6 | Number(3,0) | SMALLINT NOT NULL | Effective Sequence | |
7 | Number(2,0) | SMALLINT NOT NULL | Sequence Number | |
8 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
9 | ADJ_REASON | Character(50) | VARCHAR2(50) NOT NULL | Adjustment Reason |