GP_ABS_INTF_LOG (SQL Table)	Index Back
AM Interface Run Log Absence Management Interface Run Log.

GP_ABS_INTF_LOG

(SQL Table)

AM Interface Run Log

Absence Management Interface Run Log.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 ABS_PAY_SYSTEM_CD 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 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

4 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	ABS_PAY_SYSTEM_CD	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	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
4	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation