GP_ABS_PISTM_VW (SQL View)	Index Back
AM Payroll Interf Stream Log Absence Management Payroll Interface Stream View of Create Date Time.

GP_ABS_PISTM_VW

(SQL View)

AM Payroll Interf Stream Log

Absence Management Payroll Interface Stream View of Create Date Time.

SELECT CAL_RUN_ID ,STRM_NUM ,CREATEDTTM FROM PS_GP_ABS_INTF_LOG WHERE ABS_PAY_SYSTEM_CD = 'PI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GP_ABS_CALRN_VW

2 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

3 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 Prompt Table: GP_ABS_CALRN_VW
2	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
3	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation