EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
APA=No Country Person
BEN=Asile Right
DEG=Military Service Done
ETR=Alien
REF=Reformed (don't do milit serv)
SER=Military Service to Come
SUR=Military Service Delayed
Prompt Table: CPAM_TBL
SCC_PERFRA_VW(SQL View) |
Index Back |
|---|---|
Person France ViewPerson France View used by personal data view SCC_PERDATA_VW. |
| SELECT P.EMPLID , F.ENTRY_DT_FRA , F.MILIT_SITUATN_FRA , F.CPAMID FROM PS_PERSON P , PS_PERS_DATA_FRA F , PS_PERSON_DT_SETUP S , PS_INSTALLATION I WHERE F.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_FRA F2, F, %CURRENTDATEIN) AND S.COUNTRY_FLG = 'Y' AND I.FRA = 'Y' UNION SELECT PX.EMPLID , %DateNull , ' ' , ' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_FRA FX , PS_PERSON_DT_SETUP SX , PS_INSTALLATION IX WHERE FX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_FRA FX2, FX, %CURRENTDATEIN) AND SX.COUNTRY_FLG = 'Y' AND IX.FRA = '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 | ENTRY_DT_FRA | Date(10) | DATE | Date of First Entry in France |
| 3 | MILIT_SITUATN_FRA | Character(3) | VARCHAR2(3) NOT NULL |
Military Status
APA=No Country Person BEN=Asile Right DEG=Military Service Done ETR=Alien REF=Reformed (don't do milit serv) SER=Military Service to Come SUR=Military Service Delayed |
| 4 | CPAMID | Character(6) | VARCHAR2(6) NOT NULL |
CPAM ID
Prompt Table: CPAM_TBL |