|
SELECT A.SETID ,A.JOBCODE ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.JOB_FUNCTION ,A.SETID_SALARY ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP ,A.MANAGER_LEVEL ,A.SURVEY_SALARY ,A.SURVEY_JOB_CODE ,A.UNION_CD ,A.RETRO_RATE ,A.RETRO_PERCENT ,A.CURRENCY_CD ,A.STD_HOURS ,A.STD_HRS_FREQUENCY ,A.COMP_FREQUENCY ,A.WORKERS_COMP_CD ,A.JOB_FAMILY ,A.JOB_KNOWHOW_POINTS ,A.JOB_ACCNTAB_POINTS ,A.JOB_PROBSLV_POINTS ,A.JOB_POINTS_TOTAL ,A.JOB_KNOWHOW_PCT ,A.JOB_ACCNTAB_PCT ,A.JOB_PROBSLV_PCT ,A.REG_TEMP ,A.DIRECTLY_TIPPED ,A.MED_CHKUP_REQ ,%subrec(JOBCD_USA_SBR, A) ,%subrec(JOBCD_CAN_SBR, A) ,%subrec(JOBCD_GER_SBR, A) ,%subrec(JOBCD_FRA_SBR, A) ,%subrec(JOBCD_UK_SBR, A) ,%subrec(JOBCD_FED_SBR, A) ,A.ENCUMBER_INDC ,A.POSN_MGMT_INDC ,A.EG_ACADEMIC_RANK ,A.EG_GROUP ,A.HP_STATS_DUTIES ,A.HP_STATS_RPT_FLAG ,A.ENCUMB_SAL_OPTN ,A.ENCUMB_SAL_AMT ,%subrec(JOBCD_ITA_SBR, A) ,%subrec(JOBCD_AUS_SBR, A) ,%subrec(JOBCD_AUSHE_SBR, A) ,%subrec(JOBCD_MYS_SBR, A) ,%subrec(JOBCD_FA_SBR, A) ,%subrec(JOBCD_FP_SBR, A) ,A.REG_REGION ,A.SAL_RANGE_MIN_RATE ,A.SAL_RANGE_MID_RATE ,A.SAL_RANGE_MAX_RATE ,A.SAL_RANGE_CURRENCY ,A.SAL_RANGE_FREQ ,%subrec(JOBCD_MIL_SBR, A) FROM PS_JOBCODE_TBL A
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SET_VLD_HR_02
|
| 2 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
JOB_FUNCTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Function Code
Prompt Table:
JOBFUNCTION_TBL
|
| 8 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary SetID
Prompt Table:
%SAL_SETID_PRMP
|
| 9 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
%SAL_PLN_PRMPT2
|
| 10 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%SAL_GRD_PRMPT2
|
| 11 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
Prompt Table:
%SAL_STP_PRMPT2
|
| 12 |
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
Default Value: 8
|
| 13 |
SURVEY_SALARY |
Number(8,0) |
INTEGER NOT NULL |
Survey Salary
|
| 14 |
SURVEY_JOB_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Salary Survey Job Code
|
| 15 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 16 |
RETRO_RATE |
Signed Number(8,4) |
DECIMAL(6,4) NOT NULL |
Retroactive Rate
|
| 17 |
RETRO_PERCENT |
Signed Number(8,4) |
DECIMAL(6,4) NOT NULL |
Retroactive Percent
|
| 18 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 19 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT
|
| 20 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
Default Value: OPR_DEF_TBL_HR.STD_HRS_FREQUENCY
Prompt Table:
STDHRS_FREQ_VW
|
| 21 |
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
Default Value: INSTALLATION.COMP_FREQUENCY
Prompt Table:
COMP_FREQ_VW
|
| 22 |
WORKERS_COMP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Workers' Comp Code
|
| 23 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
Prompt Table:
JOB_FAMILY_TBL
|
| 24 |
JOB_KNOWHOW_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Knowhow-Points
|
| 25 |
JOB_ACCNTAB_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Accountability-Points
|
| 26 |
JOB_PROBSLV_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Problem-Solving-Points
|
| 27 |
JOB_POINTS_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total Points
|
| 28 |
JOB_KNOWHOW_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Knowhow-Percent
|
| 29 |
JOB_ACCNTAB_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Accountability-Percent
|
| 30 |
JOB_PROBSLV_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Problem-Solving-Percent
|
| 31 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 32 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: N
|
| 33 |
MED_CHKUP_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Medical Checkup Required
Y/N Table Edit
Default Value: N
|
| 34 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status field
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
Default Value: N
|
| 35 |
EEO1CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Job Category
1=Officials and Managers
2=Professionals
3=Technicians
4=Sales Workers
5=Administrative Support Workers
6=Craft Workers
7=Operatives
8=Laborers and Helpers
9=Service Workers
A=Executive/Sr Level Officials
B=First/Mid Level Officials
N=No EEO-1 Reporting
Default Value: N
|
| 36 |
EEO4CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-4 Job Category
1=Officials and Administrators
2=Professionals
3=Technicians
4=Protective Service
5=Paraprofessionals
6=Office/Clerical
7=Skilled Craft
8=Service Maintenance
N=No EEO-4 Reporting
Default Value: N
|
| 37 |
EEO5CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
EEO-5 Job Category
1=Officials,Administrators,Mgrs
10=Librarian/Audiovisual
11=Consultants/Supv.of Instructn
12=Other Professional Staff
13=Teacher Aides
14=Technicians
15=Clerical/Secretarial
16=Service Workers
17=Craft Workers (Skilled)
18=Laborers (Unskilled)
2=Principals
3=Asst. Principals-Teaching
4=Asst. Principals-Nonteaching
5=Elementary Classroom Teachers
6=Secondary Classroom Teachers
7=Other Classroom Teachers
8=Guidance
9=Psychological
N=No EEO-5 Reporting
Default Value: N
|
| 38 |
EEO6CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-6 Job Category
1=Executive/Admin/Managerial
2=Faculty
3=Professional Nonfaculty
4=Secretarial/Clerical
5=Technical/Paraprofessional
6=Skilled Crafts
7=Service Maintenance Workers
N=No EEO-6 Reporting
Default Value: N
|
| 39 |
EEO_JOB_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
EEO Job Group
Prompt Table:
EEO_JOB_GRP_TBL
|
| 40 |
US_SOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Occupational Classif
Prompt Table:
US_SOC_TBL
|
| 41 |
IPEDSSCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
IPEDS-S Job Category
Default Value: N
|
| 42 |
US_OCC_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Classification Code
Prompt Table:
US_OCC_TBL
|
| 43 |
AVAIL_TELEWORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Available for Telework
Y/N Table Edit
|
| 44 |
BN_ACA_ELIG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
ACA (Affordable Care Act) Eligibility Indicator
A=Always Eligible
E=Eligible
I=Ineligible
U=To Be Determined
X=Excluded
|
| 45 |
CAN_PAYEQ_JOB_CLS |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Pay Equity Job Class
Prompt Table:
CAN_PAYEQ_TBL
|
| 46 |
CAN_NOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
National Occupational Classif
Prompt Table:
CAN_NOC_TBL
|
| 47 |
SEASONAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Seasonal
Y/N Table Edit
Default Value: N
|
| 48 |
BPS_ACTIVITY_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
BPS Activity
Prompt Table:
BPS_ACT_TBL
|
| 49 |
ELS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment and Labour Standards Status
1=Exempt
2=Non-Exempt
Default Value: 2
|
| 50 |
FUNCTION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Function Code
Prompt Table:
FUNCTION_CD_TBL
|
| 51 |
BA_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
BA Code
Prompt Table:
BA_CD_TBL
|
| 52 |
TECHNICAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Technical
Y/N Table Edit
|
| 53 |
MED_SURV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Medical Surveillance Required
Y/N Table Edit
Default Value: N
|
| 54 |
EMP_CATEGRY_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Category
CAD=Executive
ETA=Manager
OUV=Workman
|
| 55 |
ACTIVITY_TYPE_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Activity Type
ATE=WorkShop Personnel
AUT=Other
BUR=Office Personnel
CHA=Shoulder Worker
SIE=Corporate Personnel
|
| 56 |
INSEE_CD_FRA |
Character(4) |
VARCHAR2(4) NOT NULL |
Insee Code - FRA
Prompt Table:
INSEE_TBL_FRA
|
| 57 |
JOB_CTG_FRA_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Job Category Code - FRA
Prompt Table:
JOB_CTG_FRA_TBL
|
| 58 |
UK_SOC_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Standard Occupational Classification major groups for Northern Ireland
1=Managers and administrators
2=Professional occupations
3=Assoc prof/techn occupations
4=Clerical/sectrl occupations
5=Crafts and related occupations
6=Prsnl/prtive srvc occupations
7=Sales occupations
8=Plant and machine operatives
9=Other occupations
|
| 59 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 60 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
Prompt Table:
GVT_OCCUPATION
|
| 61 |
TRN_PROGRAM |
Character(6) |
VARCHAR2(6) NOT NULL |
Training Program
Prompt Table:
TRN_PROGRM_TBL
|
| 62 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: INSTALLATION.COMPANY
Prompt Table:
COMPANY_TBL
|
| 63 |
GVT_FUNC_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Functional Class
00=Not Applicable
11=Research
12=Research,Contract/Grant Admin
13=Development
14=Test and Evaluation
21=Design
22=Construction
23=Production
24=Install/Operations/Maintenance
31=Data Collect/Process/Analysis
32=Scientific/Technical Info
41=Standards and Specifications
42=Regulatory Enforcement/License
51=Natural Resource Operations
81=Clinical Practice/Counseling
91=Planning
92=Management
93=Teaching/Training
94=Technical Assistance/Consult
99=Other
Default Value: 00
|
| 64 |
GVT_POSN_TITLE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Official Posn Title Code
Prompt Table:
GVT_PSN_TTL_TBL
|
| 65 |
GVT_OFFICIAL_DESCR |
Character(70) |
VARCHAR2(70) NOT NULL |
Official Position Title
|
| 66 |
GVT_ORG_TTL_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Organization Posn Title Cd
Prompt Table:
GVT_ORG_PSN_TTL
|
| 67 |
GVT_ORG_TTL_DESCR |
Character(70) |
VARCHAR2(70) NOT NULL |
Organization Position Title
|
| 68 |
GVT_PAY_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Basis
BW=Bi-weekly
FB=Fee Basis
PA=Per Annum
PD=Per Diem
PH=Per Hour
PM=Per Month
PW=Piece Work
SM=Semi-monthly
SY=School Year
WC=Without Compensation
Default Value: INSTALLATION.GVT_PAY_BASIS
|
| 69 |
GVT_SUB_AGENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub-Agency
Prompt Table:
GVT_SUBAGCY_TBL
|
| 70 |
GVT_POI |
Character(4) |
VARCHAR2(4) NOT NULL |
Personnel Office ID
Prompt Table:
GVT_POI_VW
|
| 71 |
GVT_PAREN_TITLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parenthetical Title
D=(Data Transcribing)
O=(Office Automation)
S=(Stenography)
T=(Typing)
|
| 72 |
GVT_OPM_CERT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
OPM Certification Number
|
| 73 |
GVT_POSN_CLASS_STD |
Character(254) |
VARCHAR2(254) NOT NULL |
Position Classification Stds
|
| 74 |
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
Default Value: 1
|
| 75 |
GVT_IA_ACTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
IA Actions
Y/N Table Edit
Default Value: N
|
| 76 |
GVT_EXEC_FIN_DISCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Executive Financial Disclosure
Y/N Table Edit
Default Value: N
|
| 77 |
GVT_EMP_FIN_INT |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Financial Interests
Y/N Table Edit
Default Value: N
|
| 78 |
GVT_PATCOB_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
PATCOB Code
1=Exception 1
2=Exception 2
3=Exception 3
4=Exception 4
5=Exception 5
6=Exception 6
7=Exception 7
8=Exception 8
A=Administrative
B=Blue Collar
C=Clerical
M=Mixed Collar
O=Other White Collar
P=Professional
T=Technical
|
| 79 |
GVT_CLS_STANDARD |
Character(15) |
VARCHAR2(15) NOT NULL |
Classification Standard
Prompt Table:
GVT_CLS_STD_TBL
|
| 80 |
GVT_CLASSIFIER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Classifier's ID
|
| 81 |
GVT_DT_CLASSIFIED |
Date(10) |
DATE |
Date Classified
Default Value: %date
|
| 82 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table:
GVT_BARG_UNIT
|
| 83 |
GVT_FUND_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Source
A=Appropriated Funds
E=External Funds
N=Non-Appropriated Funds
O=Other Funds
|
| 84 |
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
|
| 85 |
GVT_PERF_PLAN |
Character(8) |
VARCHAR2(8) NOT NULL |
Performance Plan
Prompt Table:
GVT_PERF_PLAN
|
| 86 |
GVT_TARGET_GRADE |
Character(2) |
VARCHAR2(2) NOT NULL |
Target Grade
|
| 87 |
GVT_PI_UPD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PI upd ind
A=Applied at NFC
I=Auto Action Inserted
N=Not Ready to Process
P=In Process
R=Ready To Process
S=SINQ Error
Z=Other
|
| 88 |
GVT_NFC_FUNCTN_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal NFC field
A=Add
C=Change
D=Delete/Restore
I=Inactivate
R=Reactivate
Default Value: A
|
| 89 |
GVT_OFF_TITLEPREFX |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal NFC field
A=Apprentice
B=Data Transcription
C=Office Automation
D=Day
E=Steno/Office Automation
F=Foreman
G=General Foreman
H=Helper
I=Inspection
J=Coor
K=Supervisor
M=Instructor
N=Trainee
O=Senior
R=Leader
T=Typing
V=Stay in School
W=Night
X=Trainee Leader
Y=Stenography
|
| 90 |
GVT_NFC_PI_IND_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal NFC Field
Y/N Table Edit
Default Value: N
|
| 91 |
ENCUMBER_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Indicator
I=Encumber Immediately
N=No Encumbrance
R=Encumber on Requisition
Default Value: N
|
| 92 |
POSN_MGMT_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by Position Management
Y/N Table Edit
Default Value: Y
|
| 93 |
EG_ACADEMIC_RANK |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Rank
Prompt Table:
EG_RANK_TBL
|
| 94 |
EG_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Calculation Group
Prompt Table:
EG_CALC_SVC_VW
|
| 95 |
HP_STATS_DUTIES |
Character(2) |
VARCHAR2(2) NOT NULL |
Stats-Can Duties
10=Teaching Only
20=Teaching & Othr Responsibility
30=Research
|
| 96 |
HP_STATS_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats-Can Report Flag
B=Both Surveys
F=Full-Time Survey
N=Not Applicable
P=Part-Time Survey
Default Value: N
|
| 97 |
ENCUMB_SAL_OPTN |
Character(3) |
VARCHAR2(3) NOT NULL |
Encumber Salary Option
COM=Sum of Default Components
MAX=Salary Grade Maximum
MID=Salary Grade Midpoint
MIN=Salary Grade Minimum
STP=Salary Step
USR=User Specified Amount
Default Value: STP
|
| 98 |
ENCUMB_SAL_AMT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Encumber Salary Amount
|
| 99 |
INAIL_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
INAIL Code
Prompt Table:
JOB_ITAINAIL_VW
|
| 100 |
ASCO_CD_AUS |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to group occupations into categories
Prompt Table:
ASCO_TBL_AUS
|
| 101 |
PKG_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sal Package - Package Template ID
Prompt Table:
PKG_TMP_TBL
|
| 102 |
PKG_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sal Package - Package Rule ID
Prompt Table:
PKG_RULE_TBL
|
| 103 |
FUNCTION_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field refers to the role performed by the employee.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Teaching only function
2=Research only function
3=Teaching & Research function
4=Other function
|
| 104 |
ANN_CNTACT_HRS_AUS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field represents the total number of hours spent annually in a teaching job. The field is used for calculating FTE equivalence.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
|
| 105 |
TEACH_WEEKS_AUS |
Number(2,0) |
SMALLINT NOT NULL |
This field represents the total number of weeks worked by a member of staff in the role of teaching. The field is used for calculating FTE equivalence.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
|
| 106 |
CASUAL_TYPE_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field translates the type of work performed by a member of the staff and is used for calculating FTE equivalence for casual types.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
L=Lecturing
R=Market/Research/Other
S=Supervise/Tutorial Workshop
|
| 107 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 108 |
FA_PAY_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Festive Advance Pay Program that the Employee is enrolled in.
Prompt Table:
FA_PAY_HDR
|
| 109 |
ELECTION_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Election Group
Prompt Table:
ELECTION_GR_TBL
|
| 110 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 111 |
FP_PROF_CATG |
Character(3) |
VARCHAR2(3) NOT NULL |
Labor Agreement Category
AGT=Supervisory Officer
DIR=Director
TEC=Technician
|
| 112 |
FP_JOB_FMLY |
Character(4) |
VARCHAR2(4) NOT NULL |
CS Job Code
FEM1=Job Family 1
FEM2=Job Family 2
|
| 113 |
FP_OFF_COLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Outside Coll Lbor Agrment
Y/N Table Edit
Default Value: N
|
| 114 |
FP_MATRIX_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade Table Type
GEC=Under Contract Grid
GES=Statutory Grid
GFP=Public Service Grid
Prompt Table:
FPMMATXTYP_TBL
|
| 115 |
FP_MATRIX_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Grade Table Code
Prompt Table:
FPMSALMATRX_VW1
|
| 116 |
FP_BUSINESS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupation Code
Prompt Table:
FPMBUISNESS_TBL
|
| 117 |
FP_JOBCD_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Competencies
Y/N Table Edit
Default Value: Y
|
| 118 |
FP_ATCH_AREA |
Character(4) |
VARCHAR2(4) NOT NULL |
Attachment Sector
ADMN=Administrative Sector
OUV=Industrial Sector
PRIV=Private Sector
|
| 119 |
FP_JOB_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Job Type
CO=Public / Private
PR=Private
SP=Public
Default Value: CO
|
| 120 |
FP_AUTO_RATFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Hire Validation
Y/N Table Edit
|
| 121 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %date
|
| 122 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_STANDARD_VW
|
| 123 |
SAL_RANGE_MIN_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Salary Range Minimum Rate
|
| 124 |
SAL_RANGE_MID_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Salary Range Midpoint Rate
|
| 125 |
SAL_RANGE_MAX_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Salary Range Maximum Rate
|
| 126 |
SAL_RANGE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Range Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 127 |
SAL_RANGE_FREQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Range Frequency
Prompt Table:
COMP_FREQ_VW
|
| 128 |
MILITARY_SERVICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Service
Prompt Table:
MIL_SERVICE_TBL
|
| 129 |
MIL_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Military Rank
Prompt Table:
MIL_RANK_TBL
|
| 130 |
JOB_SUB_FUNC |
Character(3) |
VARCHAR2(3) NOT NULL |
Job sub Function
Prompt Table:
JOB_SUB_FNC_VW
|