GPBR_H07_VW

(SQL View)
Index Back

Homolognet Temporary View 07

Homolognet Temporary View 07.

SELECT PROCESS_INSTANCE , LAST_HIRE_DT , TERMINATION_DT , EMPLID , EMPL_RCD , EFFDT , EFFSEQ , GPBR_DSR_UNITS , PIN_NET_VAL FROM PS_GPBR_H02_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LAST_HIRE_DT Date(10) DATE Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
3 TERMINATION_DT Date(10) DATE Termination Date
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 GPBR_DSR_UNITS Number(1,0) SMALLINT NOT NULL Homolognet DSR Units Entitlement related the Termination Month, except in the last week.
9 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value