UPG_HRS_JOB_AET

(SQL Table)
Index Back

RS HRAT Upgrade State Rcrd

RS Applicant Tracking Upgrade State record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 HRS_JO_PST_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Posting Type
C=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
5 HRS_JO_PST_OPN_DT Date(10) DATE Job opening posting open date
6 HRS_JO_PST_CLS_DT Date(10) DATE Job opening post close date
7 COMMENTS Long Character CLOB Comment