GPJP_PERSDTA_VW(SQL View) |
Index Back |
|---|---|
Personal DataPersonal data with birth date in Japanese imperial era format. |
| SELECT PER.EMPLID ,PDE.EFFDT ,PER.BIRTHDATE ,CASE WHEN PER.BIRTHDATE >= %Sql(HJP_MEIJI_BEGIN) THEN %Sql(FUNCLIB_HJP_TO_IMP_ERA,PER.BIRTHDATE) ELSE ' ' END ,CASE WHEN PER.BIRTHDATE >= %Sql(HJP_MEIJI_BEGIN) THEN %Sql(FUNCLIB_HJP_TO_IMP_ERA_SI,PER.BIRTHDATE) ELSE ' ' END ,CASE WHEN PER.BIRTHDATE >= %Sql(HJP_MEIJI_BEGIN) THEN %Sql(FUNCLIB_HJP_TO_IMP_YYMMDD,PER.BIRTHDATE) ELSE ' ' END ,PER.DT_OF_DEATH ,PDE.MAR_STATUS ,PDE.SEX FROM PS_PERSON PER , PS_PERS_DATA_EFFDT PDE WHERE PER.EMPLID = PDE.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 4 | GPJP_CHRDT_ERA1 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 5 | GPJP_CHRDT_ERA2 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 6 | GPJP_CHRDT_YYMMDD1 | Character(6) | VARCHAR2(6) NOT NULL | Character Date as YYMMDD |
| 7 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
| 8 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed Default Value: U |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |