| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| 3 |
HR_METRIC_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to list Metric Name for Career and Succession Metrics
1=Plans for Key Entities
1CP=Available Career Plans
2=Projected Vacancy-Key People
3=Risk of Leaving-Key People
4=Career Potential
5=Key Job Codes - Incumbents
|
| 4 |
HR_SUCC_PLNTYP_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Succession Plan Type
1=Key Job Codes
2=Key People
3=Key Positions
|
| 5 |
HR_TIME_FRAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to list Time Frame for Career and Succession Metrics
CUR=Current Year
FH=Full History
L1=Last 1 Month
L12=Last 12 months
L3=Last 3 months
L6=Last 6 months
N1=Next 1 month
N12=Next 12 months
N3=Next 3 months
N6=Next 6 months
SD=Specify Dates
|
| 6 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 7 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|
| 9 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SET_VLD_HR_02
Set Control Field: BUSINESS_UNIT
|
| 10 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 11 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 12 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 13 |
DEPARTMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 14 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|