SCC_CITIZEN_QVW - Citizenship Query View (use this for reporting)
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| CITIZENSHIP_STATUS - Citizenship Status | Char1 | Status | ||
| → | COUNTRY - Country | Char3 | Country | |
| → | DEPENDENT_ID - Dependent ID | Char2 | Dep ID | |
| → | EMPLID - Empl ID | Char11 | ID | |
| PERM_STATUS_DT_SGP - Permanent Status Date | Date | Permnt Dt | ||
| WORKER_TYPE_SGP - Worker Type | Char2 | N | Workr Type |
SQL for SCC_CITIZEN_QVW
CREATE OR REPLACE VIEW SYSADM.PS_SCC_CITIZEN_QVW AS SELECT A.EMPLID, A.DEPENDENT_ID, A.COUNTRY, A.CITIZENSHIP_STATUS, A.WORKER_TYPE_SGP, A.PERM_STATUS_DT_SGP FROM PS_CITIZENSHIP A;
CITIZENSHIP - EE/Dependent Citizenship (developers only)
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| CITIZENSHIP_STATUS - Citizenship Status | Char1 | Status | ||
| → | COUNTRY - Country | Char3 | Country | |
| → | DEPENDENT_ID - Dependent ID | Char2 | Dep ID | |
| → | EMPLID - Empl ID | Char11 | ID | |
| PERM_STATUS_DT_SGP - Permanent Status Date | Date | Permnt Dt | ||
| WORKER_TYPE_SGP - Worker Type | Char2 | N | Workr Type |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
Related Info
