HRS_TMPL_PG_TMP

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JO_TMPL_SCTN Character(3) VARCHAR2(3) NOT NULL Job Opening Template Sections
010=Job Information
020=Staffing Information
025=Salary Information
030=Education and Experience
035=Degrees
040=Licenses and Certificates
050=Languages
060=Memberships
070=Honors and Awards
080=Tests
090=Competencies
100=Screening Question
110=Screening Options
120=Recruiter Assignments
122=Hiring Manager Assignments
124=Interviewer Assignments
126=Interested Party Assignments
130=Job Postings
140=Works Council Information
150=Military Rank and Service

2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JO_TMPL_SCTN	Character(3)	VARCHAR2(3) NOT NULL	Job Opening Template Sections 010=Job Information 020=Staffing Information 025=Salary Information 030=Education and Experience 035=Degrees 040=Licenses and Certificates 050=Languages 060=Memberships 070=Honors and Awards 080=Tests 090=Competencies 100=Screening Question 110=Screening Options 120=Recruiter Assignments 122=Hiring Manager Assignments 124=Interviewer Assignments 126=Interested Party Assignments 130=Job Postings 140=Works Council Information 150=Military Rank and Service
2	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).