HREESNRDATES_CV

(SQL View)
 Index Back

HR_EE_SNR_DATES MSG Clairvia

Clone of HR_EE_SNR_DATES record for Clairvia Fullsync message

SELECT HR.EMPLID , HR.EMPL_RCD , HR.EFFDT , HR.EFFSEQ , HR.LABOR_AGREEMENT , HR.SENIORITY_DATE_ID , HR.SNR_DT_CNTRL_VALUE , HR.LABOR_SENIORITY_DT , HR.LBR_OVERRIDE_FLG , HR.LBR_OVERRIDE_RSN FROM PS_HR_EE_SNR_DATES HR , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = HR.EMPLID AND ASG.EMPL_RCD = HR.EMPL_RCD 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

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: HR_LABOR_AGRMNT

6 SENIORITY_DATE_ID Character(10) VARCHAR2(10) NOT NULL Seniority Date ID

Prompt Table: HR_LBR_SNR_DATE

7 SNR_DT_CNTRL_VALUE Character(20) VARCHAR2(20) NOT NULL Seniority Date Control Value
8 LABOR_SENIORITY_DT Date(10) DATE NOT NULL Labor Senority date
9 LBR_OVERRIDE_FLG Character(1) VARCHAR2(1) NOT NULL Override Flag

Y/N Table Edit

Default Value: N

10 LBR_OVERRIDE_RSN Character(30) VARCHAR2(30) NOT NULL LBR_OVERRIDE_RSN