LEAVE_ACCRUAL (SQL Table)	Index Back
EE Leave Accruals This record is used to store employee Leave Accrual balances including hours Carried Over, Taken, Earned, Bought, Sold and Unprocessed. Warning! For technical reasons, this record's schema shows that it is keyed by EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

LEAVE_ACCRUAL

(SQL Table)

EE Leave Accruals

This record is used to store employee Leave Accrual balances including hours Carried Over, Taken, Earned, Bought, Sold and Unprocessed. Warning! For technical reasons, this record's schema shows that it is keyed by EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

Parent record: BENEFIT_PARTIC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

4 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

5 ACCRUAL_PROC_DT Date(10) DATE Accrual Process Date

6 SERVICE_HRS Signed Number(11,3) DECIMAL(9,3) NOT NULL hours of service for an employee related to benefit plan

7 HRS_CARRYOVER Signed Number(13,6) DECIMAL(11,6) NOT NULL Hours Carried Over-Prev Year

8 HRS_EARNED_YTD Signed Number(12,6) DECIMAL(10,6) NOT NULL Hours Earned Year-to-Date

9 HRS_TAKEN_YTD Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Taken Year-to-Date

10 HRS_ADJUST_YTD Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Adjusted Year-to-Date

11 HRS_BOUGHT_YTD Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Bought Year-to-Date

12 HRS_SOLD_YTD Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Sold Year-to-Date

13 SERVICE_HRS_UNPROC Signed Number(9,3) DECIMAL(7,3) NOT NULL Service Hours Unprocessed

14 HRS_TAKEN_UNPROC Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Taken Unprocessed

15 HRS_ADJUST_UNPROC Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Adjusted Unprocessed

16 HRS_BOUGHT_UNPROC Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Bought Unprocessed

17 HRS_SOLD_UNPROC Signed Number(9,3) DECIMAL(7,3) NOT NULL Hours Sold Unprocessed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
4	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
5	ACCRUAL_PROC_DT	Date(10)	DATE	Accrual Process Date
6	SERVICE_HRS	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	hours of service for an employee related to benefit plan
7	HRS_CARRYOVER	Signed Number(13,6)	DECIMAL(11,6) NOT NULL	Hours Carried Over-Prev Year
8	HRS_EARNED_YTD	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Hours Earned Year-to-Date
9	HRS_TAKEN_YTD	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Taken Year-to-Date
10	HRS_ADJUST_YTD	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Adjusted Year-to-Date
11	HRS_BOUGHT_YTD	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Bought Year-to-Date
12	HRS_SOLD_YTD	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Sold Year-to-Date
13	SERVICE_HRS_UNPROC	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Service Hours Unprocessed
14	HRS_TAKEN_UNPROC	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Taken Unprocessed
15	HRS_ADJUST_UNPROC	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Adjusted Unprocessed
16	HRS_BOUGHT_UNPROC	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Bought Unprocessed
17	HRS_SOLD_UNPROC	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Sold Unprocessed