HRS_GPODLT_HST

(SQL Table)
Index Back

Job Posting Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
4 GVT_RECR_DIST_LIST Character(6) VARCHAR2(6) NOT NULL Recruiting Distribution List
5 POSTED_DATE Date(10) DATE Date Posted
6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id