| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|
| 3 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 6 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 7 |
JOB_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job
|
| 8 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 9 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 11 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
|
| 12 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 13 |
INSTANCEID |
Number(10,0) |
DECIMAL(10) NOT NULL |
For a given worklist the unique number of rows in PSWORKLIST
|
| 14 |
TRANSACTIONID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Identifier
|
| 15 |
PROVIDER |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider
|
| 16 |
CATEGORY |
Character(10) |
VARCHAR2(10) NOT NULL |
Category Name
|
| 17 |
TC_COMP_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Compensation Source
|
| 18 |
TC_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Total Comp Plan ID
|
| 19 |
CONTRACT_NBR_BEL |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq. Number
|
| 20 |
DEPENDENT_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent ID
|
| 21 |
VISA_PERMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Visa/Permit Type
|
| 22 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 23 |
WRKS_CNCL_ID_LCL |
Character(9) |
VARCHAR2(9) NOT NULL |
Works Council ID
|
| 24 |
SI_UNIT |
Character(6) |
VARCHAR2(6) NOT NULL |
Social Insurance Unit
|
| 25 |
SPK_COMM_ID_GER |
Character(9) |
VARCHAR2(9) NOT NULL |
Spokesmen Committee ID
|
| 26 |
PENSION_CMP_CD_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Pension Company Code
|
| 27 |
PENSION1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Pension 1
|
| 28 |
PENSION2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Pension 2
|
| 29 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 30 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 31 |
EVALUATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self
|
| 32 |
REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
|
| 33 |
FACTOR_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Factor Weight
|
| 34 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 35 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 36 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 37 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| 38 |
REC_GROUP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Group ID
|
| 39 |
DATE_ACQUIRED |
Date(10) |
DATE |
Date Acquired
|
| 40 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 41 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 42 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 43 |
BUDGET_START_DT |
Date(10) |
DATE |
Budget Period Start Date
|
| 44 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 45 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 46 |
REQUESTED_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Requested Percent
|
| 47 |
REQUESTED_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Requested Amount
|
| 48 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 49 |
CURR_BUDGET_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Current Budget Percent
|
| 50 |
CURR_BUDGET_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Current Budget Amount
|
| 51 |
BUDGET_APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Approved
|
| 52 |
POINTS |
Number(4,0) |
SMALLINT NOT NULL |
Points
|
| 53 |
CM_IMPORTANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Competency Importance
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
|
| 54 |
CM_IMPORTANCE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Competency Importance
|
| 55 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 56 |
EXCHNG_TO_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 57 |
NEW_HIRE_ELIG_DT |
Date(10) |
DATE |
New Hire Eligibility Date
|
| 58 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 59 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 60 |
EMPLOY_CATEGRY_FRA |
Character(6) |
VARCHAR2(6) NOT NULL |
Category Code
|
| 61 |
EMPL_CAT_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Category
|
| 62 |
EMPL_SUBCAT_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Subcategory
|
| 63 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 64 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 65 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 66 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
|
| 67 |
STEP_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Step ID
|
| 68 |
DEGREE |
Character(8) |
VARCHAR2(8) NOT NULL |
Degree
|
| 69 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 70 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 71 |
REVIEWER_APPRVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewer is Approved
|
| 72 |
REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
|
| 73 |
BANK_BS_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Bank/Building Society Name
|
| 74 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 75 |
TRANSIT_NUM |
Character(9) |
VARCHAR2(9) NOT NULL |
Bank Transit #
|
| 76 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 77 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
|
| 78 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 79 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 80 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 81 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 82 |
BUDGET_APPROVAL_DT |
Date(10) |
DATE |
Budget Approval Date
|
| 83 |
APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
|
| 84 |
APPRVL_DT |
Date(10) |
DATE |
Approval Date
|
| 85 |
APPROVER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver EmplID
|
| 86 |
TOTAL_CALC_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Budget Amount
|
| 87 |
TOTAL_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Total Count
|
| 88 |
TOTAL_PERCENT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Total Percent Increases
|
| 89 |
AVG_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Average Percent by Actn Reason
|
| 90 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 91 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 92 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 93 |
ANNIVERSARY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Anniversary Raises
|
| 94 |
BUDGET_END_DT |
Date(10) |
DATE |
Budget End Date
|
| 95 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 96 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 97 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 98 |
CONTRACT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq#
|
| 99 |
UPG_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 100 |
UPG_CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 101 |
UPG_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 102 |
UPG_CONTRACT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq#
|
| 103 |
UPG_EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 104 |
UPG_CONTRCT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq#
|
| 105 |
CONTRACT_CLAUSE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Clause
|
| 106 |
CM_CLUSTER |
Character(6) |
VARCHAR2(6) NOT NULL |
Competency Cluster
|
| 107 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 108 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
|
| 109 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 110 |
RATING_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Scale
|
| 111 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
|
| 112 |
REVIEW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 113 |
EVALUATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation ID
|
| 114 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 115 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 116 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 117 |
AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Dollar Amount
|
| 118 |
ACCUM_AMT |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Accumulation Amount
|
| 119 |
CREDIT_CARD_ISSUER |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Issuer
|
| 120 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Card Vendor
|
| 121 |
EST_COMPLETION_DT |
Date(10) |
DATE |
Estimated Completion Date
|
| 122 |
MENTOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mentor Type
1=Mentor
2=Coach
3=Endorser
4=Reviewer/Rater
5=Supervisor
6=Functional Specialist
7=Teacher
8=Other
|
| 123 |
CAREER_GOAL |
Character(40) |
VARCHAR2(40) NOT NULL |
Career Goal
|
| 124 |
ACT_COMPLETION_DT |
Date(10) |
DATE |
Actual Completion Date
|
| 125 |
GVT_SELF_DEVELOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit
Default Value: N
|
| 126 |
GVT_ESTIMATED_COST |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Estimated Cost
|
| 127 |
GVT_ACTUAL_COST |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Actual Cost
|
| 128 |
GVT_ACT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Activity Status
1=Requested
2=Approved
3=Disapproved
4=Deferred
5=In Progress
6=Completed
|
| 129 |
GVT_REQD_ACTVTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Required
Y/N Table Edit
Default Value: N
|
| 130 |
NEED_IDENTIFIED_DT |
Date(10) |
DATE |
Date Need Identified
|
| 131 |
GVT_ACTVTY_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Activity Pursued
CM=Compliance
DV=Development
EN=Enrichment
JR=Job Requirement
LC=License Renewal
MD=Management Discretion
RQ=Requalification
SE=Skill Enhancement
|
| 132 |
RANK |
Number(3,0) |
SMALLINT NOT NULL |
Force Ranking
|
| 133 |
RANKING_GROUP |
Number(3,0) |
SMALLINT NOT NULL |
Ranking Group
|
| 134 |
RANKING_GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Group Type
D=Department
F=Function
J=Jobcode
M=Manager Level
O=Other
P=Project Team
W=Work Group
|
| 135 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 136 |
DEPENDENT_BENEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default
|
| 137 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 138 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 139 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 140 |
NON_EMPLOYEE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Non-Employee ID
|
| 141 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 142 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 143 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 144 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 145 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 146 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 147 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 148 |
SAL_PLAN_DFLT |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Plan Default
|
| 149 |
STEP_DFLT |
Number(2,0) |
SMALLINT NOT NULL |
Step Default
|
| 150 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
|
| 151 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 152 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 153 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 154 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 155 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 156 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 157 |
END_DT |
Date(10) |
DATE |
end date
|
| 158 |
ENDING_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Job Title
|
| 159 |
ENDING_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Ending Pay Rate
|
| 160 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 161 |
US_SOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Occupational Classif
|
| 162 |
CAN_NOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
National Occupational Classif
|
| 163 |
REL_WRK_EXPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Relevant Work Experience
|
| 164 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 165 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 166 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 167 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
|
| 168 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)
|
| 169 |
GVT_HOURS_PER_WEEK |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Hours Per Week
|
| 170 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 171 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 172 |
GVT_TYPE_OF_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Experience Type
F=Federal Civilian Sector
O=Other
P=Private Sector
|
| 173 |
TOTAL_EE_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Total Review Points
|
| 174 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 175 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 176 |
CHANGE_PTS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Change Points
|
| 177 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 178 |
COMP_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Comp Percent
|
| 179 |
COMP_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Compensation Eff Sequence
|
| 180 |
CMPN_RATE |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Compensation Rate
|
| 181 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 182 |
COMP_RATE_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Comp Rate Points
|
| 183 |
CONVERT_COMPRT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Converted Comp Rate
|
| 184 |
FTE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply FTE for Annualization
|
| 185 |
MANUAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Switch
|
| 186 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 187 |
RATE_CODE_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Rate Code Group Name
|
| 188 |
NULL_WORK_DATE |
Date(10) |
DATE |
This field is used for the HRMS 8 Upgrade.
|
| 189 |
YR_LAST_USED |
Number(4,0) |
SMALLINT NOT NULL |
Year Last Used
|
| 190 |
HOW_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Verified By
E=Employee Claim
J=On the Job Training
N=Not Verified
O=Employer Observation
T=By Test
V=NVQ Authority
|
| 191 |
PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency
|
| 192 |
INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Level
|
| 193 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 194 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 195 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 196 |
PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Test
|
| 197 |
ISSUED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issued By
|
| 198 |
LICENSE_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
License Verified
|
| 199 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
|
| 200 |
NATIVE_LANGUAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Language
|
| 201 |
TRANSLATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Translate
|
| 202 |
TEACHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Teach
|
| 203 |
SPEAK_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low
2=Moderate
3=High
|
| 204 |
READ_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low
2=Moderate
3=High
|
| 205 |
WRITE_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low
2=Moderate
3=High
|
| 206 |
MANDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate
|
| 207 |
MANDATE_FUNCTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate Position
|
| 208 |
MAJOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Major
|
| 209 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern. Professional Education
|
| 210 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 211 |
GRADUATE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduated
|
| 212 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
|
| 213 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 214 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
|
| 215 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
|
| 216 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
|
| 217 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Practical Grade
|
| 218 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Theoretical Grade
|
| 219 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 220 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 221 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus
|
| 222 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Hours
|
| 223 |
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
|
| 224 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 225 |
EDUCATION_LVL_ACHV |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Level Achieved
|
| 226 |
COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
|
| 227 |
AREA_OF_STDY_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Area Of Study Grade
|
| 228 |
PRIMARY_NID |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary ID
|
| 229 |
SSN_KEY_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Social Security # Key
|
| 230 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
|
| 231 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 232 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 233 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 234 |
OFFER_COMPONENT |
Character(7) |
VARCHAR2(7) NOT NULL |
Offer Component
|
| 235 |
NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Name
|
| 236 |
UPG_COUNTER |
Number(11,0) |
DECIMAL(11) NOT NULL |
Row Counter
|
| 237 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
|
| 238 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
|
| 239 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 240 |
RE_JOIN_DSB_EE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
|
| 241 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion Employee
0=None
1=Social Exclusion
2=Domestic Violence Victim
3=Gender Violence Victim
4=Soc Excl - Insertion Itinerary
5=Soc Excl - Relapse
|
| 242 |
UNEMPLYMNT_CND_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Condition
1=Booked in Unemployment Office
2=Booked in Office more than 12
3=Agricultural
4=With subsidy over one year
5=Booked in Office more than 6 m
6=With One-yr-remaining Subsidy
7=W/ subsidy. Older than 52 yrs.
A=W/ Benefit. RDL 2/2009
B=With Employability Problems
C=Unemployed at 1-1-2011
D=Unemployed at 1-1-2011. 12/18
E=Unemployed 16-08-2011
F=Unemployed with Family support
G=Unemployed >6 m. Fam Support
H=Under 3 m. of work experience
I=Unemployed from another sector
J=Youth Employment
K=Unemployed w/o Education Certf
M=Part Time<333. RDL 2/2009
P=RDL 3/2014 - Fix rate
R=RDL 1/2015 Reduced rate
|
| 243 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 244 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
|
| 245 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Title
|