| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 REFERRAL_PGM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Employee referral program ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: HRS_REF_PGM.DESCR
|
| 6 |
USE_ERP_ASOF |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Program As Of
H=Applicant's Hire Date
R=Referral Date
Default Value: R
|
| 7 |
REQUIRE_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Approval for Payment
Y/N Table Edit
Default Value: N
|
| 8 |
SEPCHK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit
Default Value: N
|
| 9 |
ALLOW_DUPS_TO_EXCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Dups to Exceed Original
Y/N Table Edit
Default Value: N
|
| 10 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Limit Referral Life Span To
Default Value: 0
|
| 11 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: M
|
| 12 |
DISQUALIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Disqualify if Appl Rpts to EE
Y/N Table Edit
Default Value: N
|
| 13 |
MANAGER_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
|
| 14 |
ALLOW_PREVIOUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Previous Employees
Y/N Table Edit
Default Value: Y
|
| 15 |
DURATION_AWAY |
Number(5,0) |
INTEGER NOT NULL |
Prior to Last Date Worked
Default Value: 0
|
| 16 |
DURATION_AWAY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: M
|
| 17 |
CRT_DT_TYPE_ER |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior To
H=Applicant's Hire Date
R=Referral Date
Default Value: H
|
| 18 |
ALLOW_FAMILY |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Family Member Referrals
Y/N Table Edit
Default Value: Y
|
| 19 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 20 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 21 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 22 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 23 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|