UPG_HRS_REF_AET

(SQL Table)
Index Back

Applicant References

Use APP_ REFERENCE to record personal and professional references supplied by an applicant for employment. This data is part of the Recruitment module.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
4 HRS_REFERENCE_NUM Character(15) VARCHAR2(15) NOT NULL reference number
5 APP_DT Date(10) DATE Date an application was submitted
6 HRS_PERSON_ID_LAST Number(15,0) DECIMAL(15) NOT NULL Last Person Id counter
7 DT_CONTACTD Date(10) DATE Date Contacted
8 REFERENCE_TYPE Character(1) VARCHAR2(1) NOT NULL Reference Type
1=Professional
2=Personal
3=Both
9 REF_NAME Character(50) VARCHAR2(50) NOT NULL Reference Name
10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
11 REF_TITLE Character(20) VARCHAR2(20) NOT NULL Title
12 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
31 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
32 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
33 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
34 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
35 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
36 COMMENTS Long Character CLOB Comment
37 REFERRAL_PGM_ID Character(12) VARCHAR2(12) NOT NULL Employee referral program ID
38 EFFDT Date(10) DATE Effective Date
39 DESCR Character(30) VARCHAR2(30) NOT NULL Description
40 RULE_TYPE_ER Character(1) VARCHAR2(1) NOT NULL ERP Rule Type
A=Award Category
E=Employee Eligibility
H=Hot Job
41 RULE_ID_ER Character(12) VARCHAR2(12) NOT NULL Rule ID
42 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
43 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number