GPBR_HOM_VAC_WA

(SQL Table)
Index Back

Homolognet WA Vacations

Homolognet WA Vacations and Acquisitive Periods information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 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.
9 TERMINATION_DT Date(10) DATE Termination Date
10 BEGIN_DT Date(10) DATE NOT NULL Begin Date
11 END_DATE Date(10) DATE NOT NULL End Date
12 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
13 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
14 GPBR_VAC_PAYMNT Number(1,0) SMALLINT NOT NULL Vacation Payment Indicator Homolognet
15 GPBR_UNJUST_ABS Number(3,0) SMALLINT NOT NULL Number of Unjustified Abseneces