| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 3 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 4 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 5 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 6 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 7 |
PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Test
Y/N Table Edit
Default Value: N
|
| 8 |
LICENSE_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
License/Certification Number
|
| 9 |
ISSUED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issued By
|
| 10 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 11 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
HCR_STONLY_I
|
| 12 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 13 |
LICENSE_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
License Verified
Y/N Table Edit
Default Value: N
|
| 14 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
Y/N Table Edit
Default Value: N
|
| 15 |
NATIVE_LANGUAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Language
Y/N Table Edit
Default Value: N
|
| 16 |
TRANSLATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Translate
Y/N Table Edit
Default Value: N
|
| 17 |
TEACHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Teach
Y/N Table Edit
Default Value: N
|
| 18 |
SPEAK_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low
2=Moderate
3=High
|
| 19 |
READ_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low
2=Moderate
3=High
|
| 20 |
WRITE_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low
2=Moderate
3=High
|
| 21 |
EVALUATION_DT |
Date(10) |
DATE |
Evaluation Date
|
| 22 |
MANDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate
|
| 23 |
MANDATE_FUNCTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate Position
|
| 24 |
MANDATE_BEGIN_DATE |
Date(10) |
DATE |
Mandate Begin Date
|
| 25 |
MANDATE_END_DATE |
Date(10) |
DATE |
Mandate End Date
|
| 26 |
MAJOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Major
|
| 27 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern. Professional Education
Y/N Table Edit
Default Value: N
|
| 28 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 29 |
EDUCATOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Educator
|
| 30 |
GRADUATE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduated
Y/N Table Edit
Default Value: N
|
| 31 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 32 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
Prompt Table:
HCR_STONLY_OT_I
|
| 33 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
Prompt Table:
SCHOOL_TBL_VW
|
| 34 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 35 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
Y/N Table Edit
Default Value: N
|
| 36 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Practical Grade
|
| 37 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Theoretical Grade
|
| 38 |
GRANTOR |
Character(20) |
VARCHAR2(20) NOT NULL |
The name of the person granting the award
|
| 39 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 40 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 41 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus
|
| 42 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Hours
|
| 43 |
GVT_CRED_HRS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Hours Type
C=Continuing Education
O=Other Pay
Q=Quarter Hours
S=Semester Hours
|
| 44 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 45 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 46 |
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
|
| 47 |
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
Default Value: 97
|
| 48 |
APS_MINOR_CODE_AUS |
Character(10) |
VARCHAR2(10) NOT NULL |
Employee undertake multiple qualifications that can be classified as Major and Minor qualification. Minor code identifies the minor qualification undertaken by an employee.
Prompt Table:
MAJOR_TBL
|
| 49 |
APS_MINOR_AUS |
Character(30) |
VARCHAR2(30) NOT NULL |
This field holds the description of the minor degree attained by an individual.
|
| 50 |
NVQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
NVQ Status
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement
|
| 51 |
NVQ_START_DT |
Date(10) |
DATE |
NVQ Start Date
|
| 52 |
NVQ_COMP_DT |
Date(10) |
DATE |
NVQ Completion Date
|
| 53 |
NVQ_CERT_DT |
Date(10) |
DATE |
Certificate Award Date
|
| 54 |
NVQ_CAND_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Registration Number
|
| 55 |
NVQ_CAND_DT |
Date(10) |
DATE |
Registration Date
|
| 56 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Subject
Prompt Table:
FPMSUBJECTS
|
| 57 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
Prompt Table:
FACULTY_TBL_JPN
|
| 58 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 59 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
Prompt Table:
SBFCLTY_TBL_JPN
|
| 60 |
SUBFACULTY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Sub Faculty Name(Description)(Japan HR)
|
| 61 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 62 |
JPM_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
|
| 63 |
JPM_DISTINCT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Discinct Indicator
|
| 64 |
JPM_ITEM_KEY_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
|
| 65 |
JPM_TEXT254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
User Text - 254 Char
|
| 66 |
NVQ_REVIEWER |
Character(11) |
VARCHAR2(11) NOT NULL |
Review ID
|
| 67 |
NVQ_REVIEW_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Review Type
BRF=Brief Meeting
MET=Standard Meeting
REQ=Requested
REV=Official Review
Default Value: MET
|
| 68 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 69 |
FT_ALTERNATE_REC |
Character(50) |
VARCHAR2(50) NOT NULL |
Source Record
|
| 70 |
FT_ALTERNATE_KEY |
Character(254) |
VARCHAR2(254) NOT NULL |
Alternate Key
|