EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
Prompt Table: STATE_MC_JPN_VW
SCC_PERJPN_VW(SQL View) |
Index Back |
|---|---|
Person Japan ViewPerson Japan View used by personal data view SCC_PERDATA_VW. |
| SELECT P.EMPLID , J.HONSEKI_JPN FROM PS_PERSON P , PS_PERS_DATA_JPN J , PS_PERSON_DT_SETUP S , PS_INSTALLATION I WHERE J.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_JPN J2, J, %CURRENTDATEIN) AND S.COUNTRY_FLG = 'Y' AND I.JPN = 'Y' UNION SELECT PX.EMPLID , ' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_JPN JX , PS_PERSON_DT_SETUP SX , PS_INSTALLATION IX WHERE JX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_JPN JX2, JX, %CURRENTDATEIN) AND SX.COUNTRY_FLG = 'Y' AND IX.JPN = '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 | HONSEKI_JPN | Character(2) | VARCHAR2(2) NOT NULL |
Honseki Prefecture
Prompt Table: STATE_MC_JPN_VW |