EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
1=Service Completed
2=Exempt from Service
3=Not Applicable
4=Mandatory
5=No Information
Prompt Table: PERSON_NAME
SCC_PERDEU_VW(SQL View) |
Index Back |
|---|---|
Person German ViewPerson German View used by personal data view SCC_PERDATA_VW. |
| SELECT P.EMPLID , G.MILITARY_STAT_GER , G.EXPCTD_MILITARY_DT , G.HR_RESPONSIBLE_ID FROM PS_PERSON P , PS_PERS_DATA_DEU G , PS_PERSON_DT_SETUP S , PS_INSTALLATION I WHERE G.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_DEU G2, G, %CURRENTDATEIN) AND S.COUNTRY_FLG = 'Y' AND I.GER = 'Y' UNION SELECT PX.EMPLID , ' ' , %DateNull , ' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_DEU GX , PS_PERSON_DT_SETUP SX , PS_INSTALLATION IX WHERE GX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_DEU GX2, GX, %CURRENTDATEIN) AND SX.COUNTRY_FLG = 'Y' AND IX.GER = '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 | MILITARY_STAT_GER | Character(1) | VARCHAR2(1) NOT NULL |
Military Status
1=Service Completed 2=Exempt from Service 3=Not Applicable 4=Mandatory 5=No Information |
| 3 | EXPCTD_MILITARY_DT | Date(10) | DATE | Expected Military Date |
| 4 | HR_RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
HR Responsible ID
Prompt Table: PERSON_NAME |