| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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.
Prompt Table:
JPM_CAT_TYPES
|
| 2 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table:
JPM_CAT_ITEMS
|
| 3 |
JPM_IMPORTANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Relative Importance
1=1- Low
2=2 - Below Average
3=3 - Average
4=4 - Above Average
5=5 - High
|
| 4 |
JPM_MANDATORY |
Character(1) |
VARCHAR2(1) NOT NULL |
jpm
N=No
Y=Yes
|
| 5 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table:
RATING_MDL_TBL
|
| 6 |
JPM_RATING1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating 1
Prompt Table:
REVW_RATING_TBL
|
| 7 |
JPM_RATING2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating 2
Prompt Table:
JPM_RATING_VW1
|
| 8 |
JPM_RATING3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating 3
Prompt Table:
JPM_RATING_VW2
|
| 9 |
NVQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
NVQ Status
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement
|
| 10 |
JPM_INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Level
Prompt Table:
INT_RATING_VW
|
| 11 |
JPM_YN_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Yes/No (1)
N=No
Y=Yes
|
| 12 |
JPM_YN_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Yes/No (2)
N=No
Y=Yes
|
| 13 |
JPM_YN_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Yes/No (3)
N=No
Y=Yes
|
| 14 |
JPM_YN_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Yes/No (4)
N=No
Y=Yes
|
| 15 |
JPM_YN_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Yes/No (5)
N=No
Y=Yes
|
| 16 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 17 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
HCR_STONLY_I
|
| 18 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
Prompt Table:
SCHOOL_TBL
|
| 19 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
Prompt Table:
MAJOR_TBL
|
| 20 |
JPM_MINOR_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Minor Code
Prompt Table:
JPM_MAJOR_VW
|
| 21 |
EDUC_LVL_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field refers to the highest education attained by the member of staff.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
0=Non-Academic
1=Higher Degree
2=Bachelor's Degree
3=Other
4=No Info
|
| 22 |
APS_HEDUC_CD_AUS |
Character(2) |
VARCHAR2(2) NOT NULL |
The APS maintains a list of education codes that should be used for reporting purposes. Users should select the APS code to an existing education code in the system.
01=Doctorate
02=Masters
03=Postgraduate Diploma
04=Bachelor Degree
05=Undergraduate Diploma
06=Associate Diploma
07=Skilled Vocational Qualificatn
08=Basic Vocational Qualification
09=Year 12 (Higher School Cert)
11=Year 11
12=Year 10 (Leaving/School Cert)
13=Less than Year 10
97=Chose not to Give
|
| 23 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
Prompt Table:
FACULTY_TBL_JPN
|
| 24 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
Prompt Table:
SBFCLTY_TBL_JPN
|
| 25 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 26 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Subject
Prompt Table:
FPMSUBJECTS
|
| 27 |
FP_SKIL_HIR |
Character(1) |
VARCHAR2(1) NOT NULL |
Hiring Requirements
N=No
Y=Yes
|
| 28 |
FP_SKIL_PRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotion Requirements
N=No
Y=Yes
|
| 29 |
FP_SKIL_TEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Tenure Requirements
N=No
Y=Yes
|
| 30 |
FP_DEGR_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Required ?
N=No
Y=Yes
|