EMPLIDEFFDTDefault Value: %date
Prompt Table: HUKOU_T_DTL_CHN
Prompt Table: HUKOU_L_DTL_CHN
PERS_HUK_CHN_CV(SQL View) |
Index Back |
|---|---|
PERS_HUKOU_CHN MSG ClairviaClone of PERS_HUKOU_CHN record for Clairvia Fullsync message |
| SELECT CHN.EMPLID , CHN.EFFDT , CHN.HUKOU_TYPE_CHN , CHN.CONTRIB_AREA_CHN FROM PS_PERS_HUKOU_CHN CHN , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_HUKOU_CHN,CHN,%CurrentDateIn) AND ASG.EMPLID = CHN.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' |
| # | 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 | HUKOU_TYPE_CHN | Character(20) | VARCHAR2(20) NOT NULL |
Hukou Type
Prompt Table: HUKOU_T_DTL_CHN |
| 4 | CONTRIB_AREA_CHN | Character(30) | VARCHAR2(30) NOT NULL |
Hukou Location
Prompt Table: HUKOU_L_DTL_CHN |