GP_ABS_PISTM_VW

(SQL View)
Index Back

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