HCR_JOB_RVW_TBL

(SQL Table)
Index Back

Job row review

Review table for Job data modernization. EFFDT_PAST,EFFSEQ_PAST stores the corrected row info which triggered the review

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: PER_ORG_ASGN.EMPLID

Prompt Table: PERS_SRCH_GBL

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 REVIEW_NEEDED Character(1) VARCHAR2(1) NOT NULL Review Needed

Y/N Table Edit

Default Value: N

6 EFFDT_PAST Date(10) DATE Effective Date
7 EFFSEQ_PAST Number(3,0) SMALLINT NOT NULL Effective Sequence