HRS_JO_PST_VW1 (SQL View)	Index Back
Job Opening Posting Descr Job opening posting descriptions.

HRS_JO_PST_VW1

(SQL View)

Job Opening Posting Descr

Job opening posting descriptions.

SELECT A.HRS_JOB_OPENING_ID , a.hrs_jo_pst_seq , a.hrs_seq_num , a.hrs_jo_descr_typ , a.app_visible , d.hrs_seq_num , a.descrlong FROM ps_HRS_JO_PST_DSCR A , PS_HRS_JOB_OPENING B , ps_HRS_RCRT_TMPL C , ps_HRS_JO_DTYP_VW D WHERE a.hrs_job_opening_id = B.hrs_job_opening_id AND b.hrs_rcrt_tmpl_id = C.hrs_rcrt_tmpl_id AND c.hrs_pst_tmpl_id = D.hrs_pst_tmpl_id AND a.hrs_jo_descr_typ = d.hrs_jo_descr_typ AND c.effdt=( SELECT MAX(e.effdt) FROM ps_HRS_RCRT_TMPL E WHERE E.hrs_rcrt_tmpl_id=c.hrs_rcrt_tmpl_id AND (E.EFFDT) <=%DatePart(A.HRS_ROW_UPD_DTTM) AND E.EFF_STATUS='A')

Related Language Record: HRS_PSTDSCR_LNG

Parent record: HRS_JO_POSTING

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
Prompt Table: HRS_JOB_OPENING

2 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence
Prompt Table: HRS_JO_POSTING

3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 HRS_JO_DESCR_TYP Character(2) VARCHAR2(2) NOT NULL Job posting description type
Prompt Table: HRS_JO_DTYP_VW

5 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

6 HRS_JO_PST_DSC_SEQ Number(15,0) DECIMAL(15) NOT NULL Job opening posting description id

7 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JOB_OPENING
2	HRS_JO_PST_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening posting sequence Prompt Table: HRS_JO_POSTING
3	HRS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	HRS_JO_DESCR_TYP	Character(2)	VARCHAR2(2) NOT NULL	Job posting description type Prompt Table: HRS_JO_DTYP_VW
5	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
6	HRS_JO_PST_DSC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Job opening posting description id
7	DESCRLONG	Long Character	CLOB	Long Description