| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
JPM_CAT_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
The name of the type of items that will be used in a Catalog and or in a Profile.
|
| 4 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
|
| 5 |
JPM_CAT_ITEM_QUAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
|
| 6 |
JPM_CAT_ITEM_QUAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
|
| 7 |
BUDGETED_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgeted Position
Y/N Table Edit
Default Value: Y
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 9 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 10 |
COUNTER |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Counter
|
| 11 |
CONFIDENTIAL_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Confidential Position
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 13 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 16 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 18 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 19 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 20 |
ERP_TMPL |
Character(12) |
VARCHAR2(12) NOT NULL |
Employee Referral Program
|
| 21 |
FED |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Functionality
|
| 22 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 23 |
FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag1
Default Value: T
|
| 24 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
|
| 25 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 26 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 27 |
HRS_ALLOW_DUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Alow Duplicates
|
| 28 |
GVT_LEO_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
LEO/Fire Position
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
|
| 29 |
GVT_POSN_SENS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sensitivity Code
1=Non Sensitive
2=Non-Critical, Sensitive
3=Critical Sensitive
4=Special Sensitive
|
| 30 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 31 |
HRS_JOBPROFILE_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines if the job profile is used and where the it comes from
C=Job Code
F=Job Family
N=Not Used
P=Position
S=Salary Grade
|
| 32 |
HRS_JO_SCR_SUMM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
JO Screening Summary ID
|
| 33 |
HRS_RCRT_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Template ID
|
| 34 |
HRS_REQ_DFLT_TMPL |
Number(15,0) |
DECIMAL(15) NOT NULL |
Default job opening requisition template
|
| 35 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 36 |
HRS_REQ_APRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening: Requisitions Approval Flag
|
| 37 |
HRS_SCR_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening template ID
|
| 38 |
HRS_SCREENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening ID
|
| 39 |
HRS_STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Applicant Status
|
| 40 |
HRS_TMPL_SEGMENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Segmenting type for recruiting template
10=Business Unit
20=Company
30=Department
40=Job Profile
50=Job Family
60=Job Code
70=Salary Grade
|
| 41 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 42 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 43 |
JOB_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Job Profile ID
|
| 44 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 45 |
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
|
| 46 |
MAX_HEAD_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Max Head Count
|
| 47 |
ORIGINATOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Originator's ID
|
| 48 |
OPENINGS_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Tracks number of openings
|
| 49 |
OPENINGS_TARGET |
Number(3,0) |
SMALLINT NOT NULL |
Tracks number of target openings
|
| 50 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 51 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 52 |
POSITION_MGMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Option
F=Full Position Management
N=No Position Management
P=Partial Position Management
|
| 53 |
POSN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Status
A=Approved
P=Proposed
R=Frozen
|
| 54 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 55 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 56 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 57 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 58 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
|
| 59 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 60 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 61 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
|
| 62 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 63 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 64 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table:
STDHRS_FREQ_VW
|
| 65 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 66 |
UPDATE_INCUMBENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Incumbents
|
| 67 |
GRADE_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
From Grade
|
| 68 |
GRADE_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
To Grade
|
| 69 |
STEP_FROM |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 70 |
STEP_TO |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 71 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 72 |
HRS_JPM_INTGRN |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox on Recruiting Installation table to allow TAM integration with JPM. When set to 'Y' this field will allow JPM Non-person and/or Person Profile data to be included in a TAM Job Opening.
N=No
Y=Yes
|