ACA_PERSON_VW

(SQL View)
Index Back

ACA Eligibility Person

Affordable Care Act (ACA) person view

SELECT A.EMPLID , A.ACA_GRP_ID , B.NAME , B.NAME_DISPLAY_SRCH , B.LAST_NAME_SRCH , B.SECOND_LAST_SRCH , B.LAST_NAME , B.SECOND_LAST_NAME , B.NAME_AC , B.MIDDLE_NAME FROM PS_ACA_PERSON A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 ACA_GRP_ID Character(3) VARCHAR2(3) NOT NULL ACA Common ID.

Prompt Table: ACA_ID_TBL

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
6 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
9 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME