GPTH_WCF_TMP2

(SQL Table)
Index Back

Temp table for WCF report

Temp table for WCF report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 PRD_END_DT Date(10) DATE Pay Period End Date
5 GPTH_M_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Monthly Compensation Rate
6 GPTH_D_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Daily Compensation Rate
7 GPTH_OT_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Other Compensation Rate (without Monthly and Daily)
8 GPTH_M_COMP_PCT Number(13,9) DECIMAL(12,9) NOT NULL Monthly Salary Percent
9 GPTH_D_COMP_PCT Number(13,9) DECIMAL(12,9) NOT NULL Daily Salary Percent
10 GPTH_OT_COMP_PCT Number(13,9) DECIMAL(12,9) NOT NULL Other Salary Percent (Not monthly and daily)