UPG_HRS_SRC (SQL Table)	Index Back
Upgrade Temp Table Upgrade Temp Table

UPG_HRS_SRC

(SQL Table)

Upgrade Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID

2 REFERRAL_SOURCE Character(2) VARCHAR2(2) NOT NULL Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
CR=College Recommendation
EE=Employee
ES=Employment Securitry Bureau
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL SubSource ID

5 HRS_SUBSOURCE_STS Character(3) VARCHAR2(3) NOT NULL Status
10=Active
20=Inactive

6 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description

7 HRS_SUBCATG Character(2) VARCHAR2(2) NOT NULL Hire Data Type Subcatagory
1=Person
11=Eligibility/Identity
12=Honors and Awards
13=Identification Data
14=Languages
15=Licenses & Certificates
16=Memberships
17=Prior Work Experience
18=Test Results
19=National ID
2=Addresses
20=Accomodation
21=Diversity
22=School Education
23=Training
24=Contract Data
25=Professional Education
26=Person Names
3=Email Addresses
4=Phones
5=Competencies
6=Appl/Person Assignment Chklist
7=Applicant/Employment Contracts
8=Bank Accounts
9=Disabilities

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_SOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Source ID
2	REFERRAL_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Referral Source AD=Advertisement AG=Agency CL=Client Referral CO=College Recruiting CR=College Recommendation EE=Employee ES=Employment Securitry Bureau FE=Former Employee JF=Job Fair JP=Job Posting OH=Open House OT=Other Source PI=Phone Inquiry UK=Unknown US=Unsolicited WI=Walk-In XR=Executive Referral XS=Executive Search
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	HRS_SUBSOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	SubSource ID
5	HRS_SUBSOURCE_STS	Character(3)	VARCHAR2(3) NOT NULL	Status 10=Active 20=Inactive
6	HRS_SUBSOURCE_DESC	Character(50)	VARCHAR2(50) NOT NULL	Subsource Description
7	HRS_SUBCATG	Character(2)	VARCHAR2(2) NOT NULL	Hire Data Type Subcatagory 1=Person 11=Eligibility/Identity 12=Honors and Awards 13=Identification Data 14=Languages 15=Licenses & Certificates 16=Memberships 17=Prior Work Experience 18=Test Results 19=National ID 2=Addresses 20=Accomodation 21=Diversity 22=School Education 23=Training 24=Contract Data 25=Professional Education 26=Person Names 3=Email Addresses 4=Phones 5=Competencies 6=Appl/Person Assignment Chklist 7=Applicant/Employment Contracts 8=Bank Accounts 9=Disabilities