HRJOBRCVR

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LJB-COMPANY
Element: Company Hr
Numeric 4
LJB-JOB-CODE
Element: Job Code
Alpha 9
LJB-LTM-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
LJB-LTM-TIME-STAMP
Element: Time
Numeric 8
LJB-ACTION-CODE
Element: Action Code
Alpha 10
LJB-ACTION-REASON
Element: Action Reason
Alpha 20
LJB-STATUS
Element: Status
Numeric 1
LJB-ERROR-FLAG
Element: Error Flag
Alpha 1
LJB-TRAN-TYPE
Element: Alphadata1
Alpha 1
LJB-MESSAGE
Element: Err Message
Alpha 60
LJB-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
LJB-RATE-OVERRIDE
Element: Rate Override
Alpha 1

N = Cannot Pay Below Normal Rate
Y = Allow Pay Below Normal Rate
LJB-BEG-SAL-RANGE
Element: Pay Range
Signed 13.4
LJB-MID-SAL-RANGE
Element: Pay Range
Signed 13.4
LJB-END-SAL-RANGE
Element: Pay Range
Signed 13.4
LJB-POINTS
Element: Points
Signed 7.2
LJB-EEO-CAT
Element: Eeo Cat
Alpha 2

01 = Official Administrator
02 = Professional
03 = Technician
04 = Protective Service
05 = Para-Professionals
06 = Office and Clerical
07 = Skilled Craft
08 = Service / Maintenance
10 = Officials and Managers
11 = Trainee
20 = Professionals
21 = Trainee
30 = Technicians
31 = Trainee
40 = Sales Workers
41 = Trainee
50 = Office and Clerical
51 = Trainee
60 = Craft Workers (Skilled)
61 = Trainee
70 = Operatives (Semi-skilled)
72 = Trainee
80 = Laborers (Unskilled)
82 = Trainee
90 = Service Workers
92 = Trainee
99 = Not Applicable
LJB-LAST-CMT-SEQ
Element: Last Cmt Seq
Numeric 4
LJB-ACTIVE-FLAG
Element: Active Flag
Alpha 1

A = Active
I = Inactive
LJB-ANNUAL-HOURS
Element: Annual Hours
Numeric 4
LJB-JOB-CLASS
Element: Job Class
Alpha 3
LJB-SCHEDULE
Element: Schedule
Alpha 9
LJB-PAY-GRADE
Element: Pay Grade
Alpha 3
LJB-EEO-SUB-CODE
Element: Eeo Sub Code
Numeric 3
LJB-EVAL-DATE
Element: Eval Date
Numeric 8 (yyyymmdd)
LJB-EXEMPT
Element: Exempt
Alpha 1

N = No
Y = Yes
LJB-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
LJB-DESC-DATE
Element: Desc Date
Numeric 8 (yyyymmdd)
LJB-WC-CLASS
Element: Wc Class
Alpha 4
LJB-CA-WC-CLASS
Element: Ca Wc Class
Alpha 10
LJB-PAY-RATE
Element: Pay Rate
Signed 13.4
LJB-EXP-DIST-CO
Element: Company
Numeric 4
LJB-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
LJB-EXP-ACCOUNT
Element: Account
Numeric 6
LJB-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
LJB-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
LJB-DEPARTMENT
Element: Department
Alpha 5
LJB-REPORTS-TO
Element: Reports To
Numeric 9
LJB-APPROVED-BY
Element: Approved By
Numeric 9
LJB-TIPPED
Element: Tipped
Alpha 1

C = Tipped job - Tax Credit
N = Not a tipped job
T = Tipped job - No Tax
LJB-OBJ-ID
Element: Obj Id
Numeric 12
LJB-EEO-CAT-1
Element: Eeo Cat 1
Derived
LJB-MARKET-SALARY
Element: Pay Range
Signed 13.4
LJB-MARKET-DATE
Element: Market Date
Numeric 8 (yyyymmdd)
LJB-CURRENCY-CODE
Element: Currency Code
Alpha 5
LJB-CURR-ND
Element: Acct Nd
Numeric 1
LJB-BASE-PAY-RATE
Element: Pay Range
Signed 13.4
LJB-BASE-CURRENCY
Element: Base Currency
Alpha 5
LJB-BASE-ND
Element: Base Nd
Numeric 1
LJB-BASE-BEG-SAL
Element: Pay Range
Signed 13.4
LJB-BASE-MID-SAL
Element: Pay Range
Signed 13.4
LJB-BASE-END-SAL
Element: Pay Range
Signed 13.4
LJB-BASE-MARKET
Element: Pay Range
Signed 13.4
LJB-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
LJB-SALARY-CLASS
Element: Salary Class
Alpha 1

H = Hourly
S = Salary
LJB-WEB-TYPE
Element: Web Type
Alpha 3

1 = Physician
2 = Nurse
LJB-GENDER-CLASS
Element: Gender Class
Alpha 1

" " = Not Applicable
1 = Female
2 = Male
3 = Gender Neutral
LJB-DIR-IND-JOB
Element: Dir Ind Job
Numeric 1

1 = Direct
2 = Indirect
LJB-OCCUP-GROUP
Element: Occup Group
Alpha 2

01 = Senior Managers
02 = Middle and Other Managers
03 = Professionals
04 = Semi-Professionals/Technicians
05 = Supervisors
06 = Supervisors/Crafts and Trades
07 = Administrators/Senior Clerical
08 = Skilled Sales/Service
09 = Skilled Crafts/Trades
10 = Clerical
11 = Intermediate Sales/Service
12 = Semi-Skilled Manual
13 = Other Sales/Service
14 = Other Manual
99 = Not Applicable
LJB-TENURE-ELIG
Element: Tenure Elig
Alpha 1

N = No
Y = Yes
" " = Not Applicable
LJB-HIGH-ED-CAT
Element: High Ed Cat
Numeric 2

01 = Exec;Admin;Mgr
02 = Faculty
03 = Other Professionals
04 = Clerical;Secretarial
05 = Technical;Paraprofessional
06 = Skilled Craft Workers
07 = Service;Maintenance
LJB-HIGH-ED-SUBCAT
Element: High Ed Subcat
Alpha 3
LJB-ACADEMIC-RANK
Element: Academic Rank
Alpha 1

1 = Professor
2 = Associate Professor
3 = Assistant Professor
4 = Instructor
5 = Lecturer
6 = Other Instructional Staff
LJB-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
LJB-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
LJB-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
LJB-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
LJB-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
LJB-USER-ID
Element: User
Alpha 10 (Lower Case)


HRJOBRCVR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LJBSET1 COMPANY
JOB-CODE
LTM-DATE-STAMP
LTM-TIME-STAMP
ACTION-CODE
LJBSET2 COMPANY
JOB-CODE
STATUS
LTM-DATE-STAMP
LTM-TIME-STAMP
ERROR-FLAG
ACTION-CODE
KeyChange
LJBSET3 COMPANY
STATUS
LTM-DATE-STAMP
LTM-TIME-STAMP
ERROR-FLAG
JOB-CODE
ACTION-CODE
KeyChange
LJBSET4 COMPANY
ACTION-CODE
STATUS
LTM-DATE-STAMP
LTM-TIME-STAMP
ERROR-FLAG
JOB-CODE
KeyChange


File created: Wed Jun 08 20:49:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.