Build Personnel and Position Actions Posted to the Mainframe File - 3135

Purpose: On a nightly basis, builds a file containing Personnel and Position Actions posted on the mainframe. File is to be used by requesting agency.
 
FREQUENCY:
Nightly
CREATED IN:
AU443135
 
Files are currently created for:
 
DEQ.S44.HRTRANS.SEQ
FGA.S44.NOMIGR.HRTRANS.SEQ
HGH.S44.HRTRANS.SEQ
 
Special Instructions:
 
The agencies are responsible for picking up their file through the ftp process each morning. If for some reason the agency does not get their file that morning, it will get overlaid with new data when the next AU443135 runs. A dataset can be recreated from the backup (if necessary and if the dataset is available) if not the dataset AUI.S44.IPR20TRN.BKUP.GDG can be used
 
FILE LAYOUT
 
FIELD NAME
COLUMN BEGIN
FIELD LENGTH
DESCRIPTION
USER_INITIALS
1
(A03)
User's initials
COMPANY_CODE
4
(A03)
Agency number
EFFECTIVE_DATE
7
(A08)
YYYYMMDD
SSN
15
(A09)
Social Security Number
TRAN_CODE
24
(A03)
Transaction type 290, 330, 400, etc
CHANGE_CODE
27
(A01)
'N', 'R' or 'D'
SUB_CODE
28
(A10)
 
DOC_ID
38
(A02)
A1 = Position
C1 = Personnel Setup
D1 = Personnel Change
F1 = Payroll/Deduction
H1 = SSN Change
MC = Multiple Change
JH = Job History
KC = Key Correction
DOC_NUMBER
40
(A06)
NOT USED
POST_CODE
46
(A01)
'P'
POST_DATE
47
(A08)
CCYYMMDD
TRAN_SOURCE_CODE
55
(A01)
'B'
 
 
 
 
200 Delete emp record
 
 
 
COMPANY_CODE
56
(A03)
Agency number
SSN
59
(A09)
Social Security Number
PAY_GROUP
68
(A02)
Employee Pay Group
01 - Regular Biweekly
06 - University Biweekly
20 - Judicial Monthly
 
 
 
 
205 SSN change
 
 
 
COMPANY_CODE
56
(A03)
Agency number
SSN
59
(A09)
Social Security Number
PAY_ GROUP
68
(A02)
Employee Pay Group
01 - Regular Biweekly
06 - University Biweekly
20 - Judicial Monthly
 
 
 
 
210 Emp set-up base information
 
 
 
LAST_NAME
56
(A22)
Employee last name, includes appendage.
FIRST_NAME
78
(A14)
Employee first name
MIDDLE_NAME
92
(A14)
Employee middle name
MAILING_ADDRESS
106
(A32)
Employee mailing address
MAILING_CITY
138
(A20)
Employee mailing city
MAILING_STATE
158
(A02)
Employee mailing state code
MAILING_ZIP_CODE
160
(A09)
Employee mailing zip code
BIRTH_DATE
169
(A08)
Birth date (MMDDCCYY)
CITIZENSHIP
177
(A02)
NOT USED
SEX
179
(A01)
Employee sex - 'F' or 'M'
RACE
180
(A01)
Employee race - 'A', 'B', 'C', 'D', or 'E'
HANDICAP_CODE
181
(A02)
NOT USED
HANDICAP_RESTRICTION
183
(A03)
NOT USED
ORIGINAL_HIRE
186
(A08)
Date employee was first hired with the state.
LATEST_HIRE
194
(A08)
MMDDYYYY
ORG_CODE
202
(A10)
NOT USED
PAY_LOCATION
212
(A04)
2 to 4 digit Pay Location - This code identifies the division and location within an agency.
COMPANY_STAT
216
(A01)
'P'
ASSIGN_LOCATION
217
(A04)
Work city
REVISION_PRINT
221
(A01)
'Y'
VET_STATUS
222
(A01)
Veteran status - 'Y' or 'N'
 
 
 
 
220 Emp update base information
 
 
 
LAST_NAME
56
(A22)
Employee last name, includes appendage.
FIRST_NAME
78
(A14)
Employee first name
MIDDLE_NAME
92
(A14)
Employee middle name
MAILING_ADDRESS
106
(A32)
Employee mailing address
MAILING_CITY
138
(A20)
Employee mailing city
MAILING_STATE
158
(A02)
Employee mailing state code
MAILING_ZIP_CODE
160
(A09)
Employee mailing zip code
BIRTH_DATE
169
(A08)
Birth Date (CCYYMMDD)
CITIZENSHIP
177
(A02)
NOT USED
SEX
179
(A01)
Employee sex - 'F' or 'M'
RACE
180
(A01)
Employee race - 'A', 'B', 'C', 'D', or 'E'
HANDICAP_CODE
181
(A02)
Veteran type code
HANDICAP_RESTRICTION
183
(A03)
NOT USED
ORIGINAL_HIRE
186
(A08)
Date employee was first hired with the state.
LATEST_HIRE
194
(A08)
MMDDYYYY
ORG_CODE
202
(A10)
 
PAY_LOCATION
212
(A04)
2 to 4 digit Pay Location - This code identifies the division and location within an agency.
COMPANY_STAT
216
(A01)
NOT USED
ASSIGN_LOCATION
217
(A04)
Work City
REVISION_PRINT
221
(A01)
NOT USED
VET_STATUS
222
(A01)
Veteran status - 'Y' or 'N'
 
 
 
 
290 Direct deposit
 
 
 
BANK_DEPOSIT
56
(A01)
'Y' or 'N'
DDP_TYPE
57
(A01)
U
DDP_PRENOTE_IND
58
(A01)
P= Pre-note
DD_ METHOD_CODE
59
(A01)
F= full, P = partial, R = remainder
DDP_AMOUNT
60
(N7.2)
Deposit amount
DD_BANK_NUMBER
69
(A09)
Bank number
DD_ACCOUNT_NUMBER
77
(A17)
Bank account number
 
 
 
 
310 Other earnings - VHT
 
 
 
ER_VARIABLE
 
(A03)
NOT USED
RATE
 
(N7.4)
NOT USED
OVERRIDE_SALARY
 
(N7.4)
NOT USED
OVERRIDE_START_DATE
 
(A08)
NOT USED
OVERRIDE_END_DATE
 
(A08)
NOT USED
EAB_ORIGINAL_ AMOUNT
 
(N7.2)
NOT USED
EAB_END_DATE
 
(A06)
NOT USED
 
 
 
 
320 Federal tax (state & FICA)
 
 
 
RESIDENT_STATE_CODE
56
(A02)
11 = Idaho
FEDERAL_TAX STATUS
58
(A01)
'S', 'M' or 'X'
FEDERAL_EXEMPTIONS
59
(N03)
Number of exemptions
FEDERAL_TAX_INDICATOR
62
(A01)
'Y' or 'N'
FICA_INDICATOR
63
(A01)
'Y' or 'N'
STATE_TAX_INDICATOR
64
(A01)
'Y' or 'N'
FEDERAL_ADDITIONAL_TYPE
65
(A01)
NOT USED
FED_ADDITIONAL_WITHHOLD_AMT
66
(N05)
Additional amount to withhold
 
 
 
 
321 State tax & work comp
 
 
 
STATE_TAX_STATUS
56
(A01)
'S', 'M' or 'X'
STATE_EXEMPTIONS
57
(N03)
Number of exemptions
STATE_ADDITIONAL_TYPE
60
(A01)
NOT USED
STATE_ADDITIONAL_WITHHOLD_AMT
61
(N05)
Additional amount to withhold
STATE_WORK_COMP_CODE
66
(A04)
Agency assigned workers compensation code
 
 
 
 
330 Employee voluntary ded
 
 
 
DED_VARIABLE
56
(A03)
NOT USED
DED_EFFECTIVE_END
59
(A08)
YYYYMMDD
DED_STATUS
67
(A01)
'Y' or 'N'
DED_SCHEDULE
68
(A02)
App code plus a blank
DED_RATE
70
(N7.4)
Deduction amount/rate
DED_OVERRIDE_AMOUNT
81
(N7.2)
Deduction override amount
DED_OVERRIDE_START_DATE
90
(A08)
Deduction override start date (CCYYMMDD)
DED_OVERRIDE_END_DATE
98
(A08)
Deduction override end date (CCYYMMDD)
DED_SAVINGS_BOND_KEY
106
(A03)
NOT USED
DED_SAVINGS_BOND_AMT
109
(N03)
NOT USED
DED_SAVINGS_BOND_LIMIT_AMT
112
(N7.2)
NOT USED
DED_ACCOUNT_NUMBER
121
(A30)
 Account number
 
 
 
 
332 Employer ded
 
 
 
HEALTH_INS_ELIG_CODE
56
(A01)
Health eligibility indicator E = eligible, N = not eligible
HEALTH_INS_PLAN_CODE
57
(A02)
Health insurance option
LIFE_INS_ELIG_CODE
59
(A01)
Life insurance eligibility indicator E = eligible, N = not eligible
LIFE_INS_PLAN_CODE
60
(A02)
Life Insurance option -
LB - participating Legislator under 70
LC - participating regular
LM - participating Legislator over 70
LP - pro-rated employee
NE - not eligible
RETIREMENT_CODE
62
(A01)
Retirement eligibility indicator  E = eligible, N = not eligible
RETIREMENT_PLAN_CODE
63
(A02)
Retirement option -
NE - employee not eligible
R1 - participating regular retirement
R2 - police/fire
R3 - teacher/professor
R4 - reclassed/former ret ind = 2
R5 - Dept of Employment
R6 - Judge
R7 - TIAA  - 7/1/1991
R8 - VALIC - 7/1/1991
RA - TIAA  - 7/1/1997
RB - VALIC - 7/1/1997
DENTAL_ELIG_CODE
65
(A01)
Dental insurance eligibility indicator - E = eligible, N = not eligible
DENTAL_PLAN_CODE
66
(A02)
Dental insurance option -
NE - employee not eligible
NS - no insurance remittance
NW - not wanted - declined
T1 - dental employee pre-tax
T2 - dental employee & spouse pre-tax
T3 - dental employee & child pre-tax
T4 - dental employee, spouse & child pre-tax
T5 - dental employee & children pre-tax
T6 - dental employee, spouse & children pre-tax
TA - dental employee post-tax
TB - dental employee & spouse post-tax
TC - dental employee & child post-tax
TD - dental employee, spouse & child post-tax
TE - dental employee & children post-tax
TF - dental employee, spouse & children post-tax
TIER_LEVE_CODE
68
(A01)
Insurance Tier Level Code
 
 
 
 
400 Personnel updates/appts
 
 
 
POSITION_SEQUENCE
56
(A02)
 
APPT_TYPE
58
(A03)
1. Jurisdiction code - C = classified, N = non-classified
 
2. A = acting, B = probationary, E = elected, G = appointed by Governor, P = permanent, T = provisional
X = appointed
 
3. B = board member, D = declared, E = elected, G - group employees, M - 8-month temporary, R = regular, T = temporary, X = limited
PERMANENCY
61
(A01)
Suffix code - N = not applicable, U = underfill, H = agency head
POSITION_STATUS
62
(A01)
pay status = 'A', 'B', 'I', etc
WORKING_STATUS
63
(A02)
FS, PT,  PP, etc
FULL_TIME_EQUIVALENT
65
(N1.2)
100 = full time
JOB_CLASS_OVERRIDE
68
(A10)
class code
PAY_GROUP
78
(A02)
Employee Pay Group
01 - Regular Biweekly
06 - University Biweekly
20 - Judicial Monthly
SALARY_LEVEL
80
(A03)
schedule/grade - schedule = H one extra space
SALARY_STEP
83
(A02)
not used with schedule H
PAY_CODE
85
(A01)
 
TIMESHEET_REQUIRED
86
(A01)
'Y' or 'N'
PAY_BASIS
87
(A01)
'H', 'A', 'D'
RATE
88
(N7.4)
Position rate/salary
UNEMPLOYMENT_SWITCH
99
(A01)
'Y' or 'N'
STANDARD_HOURS
100
(N3.2)
Example - 80.0
RATE_OVERRIDE_START_DATE
105
(A08)
Override start date
RATE_OVERRIDE_END_DATE
113
(A08)
Override end date
RATE_OVERRIDE
121
(N7.4)
Override rate
CHANGE_REASON_CODE
132
(A02)
Change code
FLSA
134
(A01)
FLSA code
LEAVE_CODE
135
(A02)
Leave schedule - example AA, BA, CA, DA, etc
VACATION_PCT
137
(N1.4)
NOT USED
COMP_PAYOFF_SWITCH
142
(A01)
Comp accrue switch (Y or N)
RHH_PAYOFF_SWITCH
143
(A01)
Indicates if the RHH for an employee will be automatically paid as regular hours or accrued.  This indicator is applied to the employee's record, but may be overridden per pay period via the '090' transaction -
Y = accrue
N = pay
IPC_REGISTER_NUMBER
144
(A07)
IPC register number for classified appointments
RETRO_DATE
151
(A08)
MMDDYYYY
PRIOR_POSITION_NUMBER
159
(A10)
PCN vacating from plus spaces
ADJUSTED_CONTRACT_SALARY
169
(N7.4)
Used for employees with annual salaries
SHIFT_INDICATOR
180
(A01)
Indicates if an employee will be paid shift pay automatically.  This indicator may be overridden using the '090' payroll transaction.  Shift pay occurs when an employee works 50% or more of their hours between the hours of 6:00 pm and 7:00 am.
Y = shift pay
N = no shift pay
 
POSITION CONTROL
 
FIELD NAME
COLUMN BEGIN
FIELD LENGTH
DESCRIPTION
USER_INITIALS
1
(A03)
 
COMPANY_CODE
4
(A03)
Agency number
EFFECTIVE_DATE
7
(A08)
YYYYMMDD
FISCAL_YEAR
15
(A09)
Fiscal year plus 5 spaces
TRAN_CODE
24
(A03)
Transaction type 290, 330, 400, etc
CHANGE_CODE
27
(A01)
'N', 'R' or 'D'
PCN
28
(A10)
Position Control Number
DOC_ID
38
(A02)
A1, C1, D1, etc
DOC_NUMBER
40
(A06)
 
POST_CODE
46
(A01)
'P'
POST_DATE
47
(A08)
CCYYMMDD
TRAN_SOURCE_CODE
55
(A01)
'B'
 
 
 
 
970 Position control base record
 
 
 
CHANGE_REASON
56
(A02)
80, 81, 90, etc
CLASS_CODE
58
(A10)
Position class code
FTE_PCT
68
(N1.4)
 
PAY_PERIOD_HOURS
73
(N1.4)
 
AGENCY_SECTION_UNIT
78
(A10)
 
POSITION_TYPE
88
(A03)
CL, CR, CS, NG, NR
 
 
 
 
972/973 Add-change position control distribution
 
 
 
DIST_STAT_SW - A
56
(A01)
 
DIST_COST_TYPE - A
57
(A01)
 
FUND_NUMBER - A
58
(N04)
 
PROGRAM_NBR - A
62
(N07)
 
AGENCY_USE - A
69
(A09)
 
DIST_PCT - A
78
(N1.4)
 
 
974/975 Add/update position control budget
 
 
 
BUDGETED_SALARY
56
(N7.2)
Salary
BUDGETED_BENEFITS
65
(N7.2)
Benefits
BUDGETED_HOURS
74
(N5.2)
Hours