INST_CSL_VW(SQL View) |
Index Back |
|---|---|
Inst CSL ViewSACE-98D NEW -FA05 |
| SELECT A.EMPLID , A.ADDRESS1 , A.ADDRESS2 , A.CITY , A.STATE , A.POSTAL , A.COUNTRY , C.LANG_CD , B.DISABLED , C.MAR_STATUS , C.SEX FROM PS_SCC_PRI_ADDR_VW A , PS_HCR_DISABL_I B , PS_HCR_PER_PDE_I C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND B.EMPLID = C.EMPLID AND A.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_ADDR_VW X1 WHERE X1.EMPLID = A.EMPLID) AND C.EFFDT = ( SELECT MAX(X2.EFFDT) FROM PS_HCR_PER_PDE_I X2 WHERE X2.EMPLID = C.EMPLID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 3 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 4 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 8 | PREFERRED_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Preferred Language
E=English F=French Prompt Table: HCR_LANGUAGE_I |
| 9 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a dependent is a disabled. |
| 10 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 11 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |