GP_ABS_INTF_LOG(SQL Table) |
Index Back |
---|---|
AM Interface Run LogAbsence Management Interface Run Log. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
2 | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System - used for Mapping purposes for Earnings/Deductions and Paygroups between Absence Management and Payroll for North America/Payroll Interface
NA=Payroll for North America PI=Payroll Interface |
|
3 | Number(4,0) | SMALLINT NOT NULL | Stream Number | |
4 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |