ACA_PERSON_VW(SQL View) |
Index Back |
---|---|
ACA Eligibility PersonAffordable 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 |