EMPLIDSSR_HM_CTZ_VW(SQL View) |
Index Back |
|---|---|
Student CitizenshipList of Student Citizenship to be posted to HEIMS |
| SELECT CH.EMPLID , CH.CITIZENSHIP_STATUS , PM.SSR_ELEM_358 , CH.EFFDT FROM PS_SCC_CITIZ_HIST CH , PS_SSR_MAP_358 PM WHERE CH.CITIZENSHIP_STATUS = PM.CITIZENSHIP_STATUS AND CH.EFFDT = (SELECT MIN(CH2.EFFDT) FROM PS_SCC_CITIZ_HIST CH2 WHERE CH2.CITIZENSHIP_STATUS = CH.CITIZENSHIP_STATUS AND CH2.EMPLID = CH.EMPLID) AND %EffdtCheck(SSR_MAP_358 PM2 , PM, %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Citizenship Status |
| 3 | SSR_ELEM_358 | Character(1) | VARCHAR2(1) NOT NULL | DEST Citizen/Resident Code |
| 4 | EFFDT_FROM | Date(10) | DATE | Effective Date From |