HRS_JOPSTDS_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_DESCR_TYP	Character(2)	VARCHAR2(2) NOT NULL	Job posting description type Prompt Table: HRS_JO_DSC_TYP
7	HRS_JO_PST_LIB_CD	Character(3)	VARCHAR2(3) NOT NULL	Description ID
8	APP_VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Indicates which sections of a job requisition's posting description are visible to internal applicants. An entire posting description is made up of 5 possible sections, the Organizational Marketing Statement, Responsibilities, Qualifications, Closing and Departmental Statement B=Internal and External E=External Only I=Internal Only
9	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
10	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
11	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
12	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id
13	DESCRLONG	Long Character	CLOB	Long Description