TL_GP_ABSBAL_VW (SQL View)	Index Back
Absence Balances used in TL Absence Balances used in TL

TL_GP_ABSBAL_VW

(SQL View)

Absence Balances used in TL

SELECT C.EMPLID , C.EMPL_RCD , C.PIN_NUM , C.ACM_FROM_DT , C.ACM_THRU_DT , C.ACM_PRD_OPTN , C.CALC_RSLT_VAL , SS.UNIT_TYPE , ( SELECT A.PRD_END_DT FROM PS_GP_PYE_PRC_STAT A WHERE A.EMPLID=B.EMPLID AND A.CAL_RUN_ID=B.CAL_RUN_ID AND A.EMPL_RCD=B.EMPL_RCD AND A.GP_PAYGROUP=B.GP_PAYGROUP AND A.CAL_ID=B.CAL_ID AND A.ORIG_CAL_RUN_ID=B.ORIG_CAL_RUN_ID) FROM PS_GP_RSLT_ACUM C, PS_GP_PIN_CMPNT D, PS_GP_PIN E, PS_GP_BAL_SS SS, PS_GP_CAL_RUN G, PS_GP_PYE_SEG_STAT B WHERE 1=1 AND (C.EMPL_RCD = C.EMPL_RCD_ACUM OR C.ACM_TYPE = 'N') AND C.SLICE_END_DT >= C.ACM_FROM_DT AND D.PIN_ENTL_BAL_NUM = C.PIN_NUM AND E.PIN_NUM = D.PIN_NUM AND SS.PIN_ENTL_BAL_NUM = D.PIN_NUM AND (E.USED_BY = 'A' OR E.COUNTRY = SS.COUNTRY) AND (C.CALC_RSLT_VAL <> 0 OR SS.STORE_RSLT_IF_ZERO = 'Y') AND C.CAL_RUN_ID = G.CAL_RUN_ID AND G.RUN_FINALIZED_IND = 'Y' AND B.EMPLID=C.EMPLID AND B.CAL_RUN_ID=C.CAL_RUN_ID AND B.EMPL_RCD=C.EMPL_RCD AND B.GP_PAYGROUP=C.GP_PAYGROUP AND B.CAL_ID=C.CAL_ID AND B.ORIG_CAL_RUN_ID=C.ORIG_CAL_RUN_ID AND B.RSLT_SEG_NUM=C.RSLT_SEG_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 PIN_ENTL_BAL_NUM Number(8,0) INTEGER NOT NULL Element number field

4 ACM_FROM_DT Date(10) DATE From Date

5 ACM_THRU_DT Date(10) DATE Through Date

6 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period

7 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

8 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours

9 PRD_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	PIN_ENTL_BAL_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
4	ACM_FROM_DT	Date(10)	DATE	From Date
5	ACM_THRU_DT	Date(10)	DATE	Through Date
6	ACM_PRD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Period 1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period
7	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
8	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
9	PRD_END_DT	Date(10)	DATE	Pay Period End Date