HRS_JOPSDST_HST

#	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 Prompt Table: HRS_JOB_OPENING
4	HRS_JO_PST_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening posting sequence Prompt Table: HRS_JO_POSTING
5	HRS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	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
7	HRS_SOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Source ID Prompt Table: HRS_SOURCE
8	HRS_JO_PST_OPN_DT	Date(10)	DATE	Job opening posting open date
9	HRS_JO_PST_CLS_DT	Date(10)	DATE	Job opening post close date
10	HRS_JO_PST_OPN_DFN	Character(2)	VARCHAR2(2) NOT NULL	Relative Open Date 00=0 - On Approval Date 01=1 - One day after approval 02=2 - Two days after approval 03=3 - Three days after approval 04=4 - Four days after approval 05=5 - Five days after approval 06=6 - Six days after approval 07=7 - Seven days after approval 08=8 - Eight days after approval 09=9 - Nine days after approval 10=10 - Ten days after approval
11	HRS_JO_PST_LENGTH	Number(3,0)	SMALLINT NOT NULL	Job opening posting duration
12	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
13	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
14	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
15	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id
16	COMMENTS	Long Character	CLOB	Comment