EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
0=Not Applicable
1=Service Done
2=Exempt from Service
3=Service
4=Conscientious Objector
9=No Information
SCC_PERESP_VW(SQL View) |
Index Back |
|---|---|
Person Spain ViewPerson Spain View used by personal data view SCC_PERDATA_VW. |
| SELECT P.EMPLID , E.MILIT_SITUATN_ESP , E.SOC_SEC_AFF_DT FROM PS_PERSON P , PS_PERS_DATA_ESP E , PS_PERSON_DT_SETUP S , PS_INSTALLATION I WHERE E.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_ESP E2, E, %CURRENTDATEIN) AND S.COUNTRY_FLG = 'Y' AND I.ESP = 'Y' UNION SELECT PX.EMPLID , ' ' , %DateNull FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_ESP EX , PS_PERSON_DT_SETUP SX , PS_INSTALLATION IX WHERE EX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_ESP EX2, EX, %CURRENTDATEIN) AND SX.COUNTRY_FLG = 'Y' AND IX.ESP = 'Y' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID Prompt Table: PERSON |
| 2 | MILIT_SITUATN_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Military Status
0=Not Applicable 1=Service Done 2=Exempt from Service 3=Service 4=Conscientious Objector 9=No Information |
| 3 | SOC_SEC_AFF_DT | Date(10) | DATE | Social Security Affiliation Dt |