BEN_Q_ELIG_TBD (SQL View)	Index Back
Benefits Workcenter Query Benefits Workcenter Query to find Employees with ACA Eligibility Status of TBD

BEN_Q_ELIG_TBD

(SQL View)

Benefits Workcenter Query

Benefits Workcenter Query to find Employees with ACA Eligibility Status of TBD

SELECT A.EMPLID ,P.NAME ,A.EFFDT ,A.ACA_GRP_ID ,A.ACA_NONASSESS_IND ,A.ACA_CALC_METH , S.OPRID FROM PS_ACA_PER_ELIG A , PS_PERSON_NAME P , PS_PERS_SRCH_GBL S WHERE A.BN_ACA_ELIG_IND = 'U' AND A.EMPLID = P.EMPLID AND S.EMPLID=A.EMPLID AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACA_PER_ELIG A1 WHERE A.EMPLID = A1.EMPLID AND A.ACA_GRP_ID = A1.ACA_GRP_ID AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 ACA_GRP_ID Character(3) VARCHAR2(3) NOT NULL ACA Coomon ID.

5 ACA_NONASSESS_IND Character(1) VARCHAR2(1) NOT NULL ACA Non-Assessment Period indicator
Y/N Table Edit

6 ACA_CALC_METH Character(1) VARCHAR2(1) NOT NULL ACA Calculation method.
L=Look Back
M=Monthly

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	ACA_GRP_ID	Character(3)	VARCHAR2(3) NOT NULL	ACA Coomon ID.
5	ACA_NONASSESS_IND	Character(1)	VARCHAR2(1) NOT NULL	ACA Non-Assessment Period indicator Y/N Table Edit
6	ACA_CALC_METH	Character(1)	VARCHAR2(1) NOT NULL	ACA Calculation method. L=Look Back M=Monthly
7	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).