​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 NAMECOLUMN BEGINFIELD LENGTHDESCRIPTION
USER_INITIALS1(A03)User's initials
COMPANY_CODE4(A03)Agency number
EFFECTIVE_DATE7(A08)YYYYMMDD
SSN15(A09)Social Security Number
TRAN_CODE24(A03)Transaction type 290, 330, 400, etc
CHANGE_CODE27(A01)'N', 'R' or 'D'
SUB_CODE28(A10) 
DOC_ID38(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_NUMBER40(A06)NOT USED
POST_CODE46(A01)'P'
POST_DATE47(A08)CCYYMMDD
TRAN_SOURCE_CODE55(A01)'B'
    
200 Delete emp record   
COMPANY_CODE56(A03)Agency number
SSN59(A09)Social Security Number
PAY_GROUP68(A02)

Employee Pay Group

01 - Regular Biweekly

06 - University Biweekly

20 - Judicial Monthly

    
205 SSN change   
COMPANY_CODE56(A03)Agency number
SSN59(A09)Social Security Number
PAY_ GROUP68(A02)

Employee Pay Group

01 - Regular Biweekly

06 - University Biweekly

20 - Judicial Monthly

    
210 Emp set-up base information   
LAST_NAME56(A22)Employee last name, includes appendage.
FIRST_NAME78(A14)Employee first name
MIDDLE_NAME92(A14)Employee middle name
MAILING_ADDRESS106(A32)Employee mailing address
MAILING_CITY138(A20)Employee mailing city
MAILING_STATE158(A02)Employee mailing state code
MAILING_ZIP_CODE160(A09)Employee mailing zip code
BIRTH_DATE169(A08)Birth date (MMDDCCYY)
CITIZENSHIP177(A02)NOT USED
SEX179(A01)Employee sex - 'F' or 'M'
RACE180(A01)Employee race - 'A', 'B', 'C', 'D', or 'E'
HANDICAP_CODE181(A02)NOT USED
HANDICAP_RESTRICTION183(A03)NOT USED
ORIGINAL_HIRE186(A08)Date employee was first hired with the state.
LATEST_HIRE194(A08)MMDDYYYY
ORG_CODE202(A10)NOT USED
PAY_LOCATION212(A04)2 to 4 digit Pay Location - This code identifies the division and location within an agency.
COMPANY_STAT216(A01)'P'
ASSIGN_LOCATION217(A04)Work city
REVISION_PRINT221(A01)'Y'
VET_STATUS222(A01)Veteran status - 'Y' or 'N'
    
220 Emp update base information   
LAST_NAME56(A22)Employee last name, includes appendage.
FIRST_NAME78(A14)Employee first name
MIDDLE_NAME92(A14)Employee middle name
MAILING_ADDRESS106(A32)Employee mailing address
MAILING_CITY138(A20)Employee mailing city
MAILING_STATE158(A02)Employee mailing state code
MAILING_ZIP_CODE160(A09)Employee mailing zip code
BIRTH_DATE169(A08)Birth Date (CCYYMMDD)
CITIZENSHIP177(A02)NOT USED
SEX179(A01)Employee sex - 'F' or 'M'
RACE180(A01)Employee race - 'A', 'B', 'C', 'D', or 'E'
HANDICAP_CODE181(A02)Veteran type code
HANDICAP_RESTRICTION183(A03)NOT USED
ORIGINAL_HIRE186(A08)Date employee was first hired with the state.
LATEST_HIRE194(A08)MMDDYYYY
ORG_CODE202(A10) 
PAY_LOCATION212(A04)2 to 4 digit Pay Location - This code identifies the division and location within an agency.
COMPANY_STAT216(A01)NOT USED
ASSIGN_LOCATION217(A04)Work City
REVISION_PRINT221(A01)NOT USED
VET_STATUS222(A01)Veteran status - 'Y' or 'N'
    
290 Direct deposit   
BANK_DEPOSIT56(A01)'Y' or 'N'
DDP_TYPE57(A01)U
DDP_PRENOTE_IND58(A01)P= Pre-note
DD_ METHOD_CODE59(A01)F= full, P = partial, R = remainder
DDP_AMOUNT60(N7.2)Deposit amount
DD_BANK_NUMBER69(A09)Bank number
DD_ACCOUNT_NUMBER77(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_CODE56(A02)11 = Idaho
FEDERAL_TAX STATUS58(A01)'S', 'M' or 'X'
FEDERAL_EXEMPTIONS59(N03)Number of exemptions
FEDERAL_TAX_INDICATOR62(A01)'Y' or 'N'
FICA_INDICATOR63(A01)'Y' or 'N'
STATE_TAX_INDICATOR64(A01)'Y' or 'N'
FEDERAL_ADDITIONAL_TYPE65(A01)NOT USED
FED_ADDITIONAL_WITHHOLD_AMT66(N05)Additional amount to withhold
    
321 State tax & work comp   
STATE_TAX_STATUS56(A01)'S', 'M' or 'X'
STATE_EXEMPTIONS57(N03)Number of exemptions
STATE_ADDITIONAL_TYPE60(A01)NOT USED
STATE_ADDITIONAL_WITHHOLD_AMT61(N05)Additional amount to withhold
STATE_WORK_COMP_CODE66(A04)Agency assigned workers compensation code
    
330 Employee voluntary ded   
DED_VARIABLE56(A03)NOT USED
DED_EFFECTIVE_END59(A08)YYYYMMDD
DED_STATUS67(A01)'Y' or 'N'
DED_SCHEDULE68(A02)App code plus a blank
DED_RATE70(N7.4)Deduction amount/rate
DED_OVERRIDE_AMOUNT81(N7.2)Deduction override amount
DED_OVERRIDE_START_DATE90(A08)Deduction override start date (CCYYMMDD)
DED_OVERRIDE_END_DATE98(A08)Deduction override end date (CCYYMMDD)
DED_SAVINGS_BOND_KEY106(A03)NOT USED
DED_SAVINGS_BOND_AMT109(N03)NOT USED
DED_SAVINGS_BOND_LIMIT_AMT112(N7.2)NOT USED
DED_ACCOUNT_NUMBER121(A30) Account number
    
332 Employer ded   
HEALTH_INS_ELIG_CODE56(A01)Health eligibility indicator E = eligible, N = not eligible
HEALTH_INS_PLAN_CODE57(A02)Health insurance option
LIFE_INS_ELIG_CODE59(A01)Life insurance eligibility indicator E = eligible, N = not eligible
LIFE_INS_PLAN_CODE60(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_CODE62(A01)Retirement eligibility indicator  E = eligible, N = not eligible
RETIREMENT_PLAN_CODE63(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_CODE65(A01)Dental insurance eligibility indicator - E = eligible, N = not eligible
DENTAL_PLAN_CODE66(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_CODE68(A01)Insurance Tier Level Code
    
400 Personnel updates/appts   
POSITION_SEQUENCE56(A02) 
APPT_TYPE58(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

PERMANENCY61(A01)Suffix code - N = not applicable, U = underfill, H = agency head
POSITION_STATUS62(A01)pay status = 'A', 'B', 'I', etc
WORKING_STATUS63(A02)FS, PT,  PP, etc
FULL_TIME_EQUIVALENT 65(N1.2)100 = full time
JOB_CLASS_OVERRIDE68(A10)class code
PAY_GROUP78(A02)

Employee Pay Group

01 - Regular Biweekly

06 - University Biweekly

20 - Judicial Monthly

SALARY_LEVEL80(A03)schedule/grade - schedule = H one extra space
SALARY_STEP83(A02)not used with schedule H
PAY_CODE85(A01) 
TIMESHEET_REQUIRED86(A01)'Y' or 'N'
PAY_BASIS87(A01)'H', 'A', 'D'
RATE88(N7.4)Position rate/salary
UNEMPLOYMENT_SWITCH99(A01)'Y' or 'N'
STANDARD_HOURS100(N3.2)Example - 80.0
RATE_OVERRIDE_START_DATE105(A08)Override start date
RATE_OVERRIDE_END_DATE113(A08)Override end date
RATE_OVERRIDE121(N7.4)Override rate
CHANGE_REASON_CODE132(A02)Change code
FLSA134(A01)FLSA code
LEAVE_CODE135(A02)Leave schedule - example AA, BA, CA, DA, etc
VACATION_PCT137(N1.4)NOT USED
COMP_PAYOFF_SWITCH142(A01)Comp accrue switch (Y or N)
RHH_PAYOFF_SWITCH143(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_NUMBER144(A07)IPC register number for classified appointments
RETRO_DATE151(A08)MMDDYYYY
PRIOR_POSITION_NUMBER159(A10)PCN vacating from plus spaces
ADJUSTED_CONTRACT_SALARY169(N7.4)Used for employees with annual salaries
SHIFT_INDICATOR180(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 NAMECOLUMN BEGINFIELD LENGTHDESCRIPTION
USER_INITIALS1(A03) 
COMPANY_CODE4(A03)Agency number
EFFECTIVE_DATE7(A08)YYYYMMDD
FISCAL_YEAR15(A09)Fiscal year plus 5 spaces
TRAN_CODE24(A03)Transaction type 290, 330, 400, etc
CHANGE_CODE27(A01)'N', 'R' or 'D'
PCN28(A10)Position Control Number
DOC_ID38(A02)A1, C1, D1, etc
DOC_NUMBER40(A06) 
POST_CODE46(A01)'P'
POST_DATE47(A08)CCYYMMDD
TRAN_SOURCE_CODE55(A01)'B'
    
970 Position control base record   
CHANGE_REASON56(A02)80, 81, 90, etc
CLASS_CODE58(A10)Position class code
FTE_PCT68(N1.4) 
PAY_PERIOD_HOURS73(N1.4) 
AGENCY_SECTION_UNIT78(A10) 
POSITION_TYPE88(A03)CL, CR, CS, NG, NR
    
972/973 Add-change position control distribution   
DIST_STAT_SW - A56(A01) 
DIST_COST_TYPE - A273
(A01) 
INDEX/FUND_NUMBER274
(A/N-04) 
PCA/PROGRAM_NBR - A278
(A/N-05) 
​BLANKS/SPACES
​283
​​02
AGENCY_USE - A285
(A09) 
DIST_PCT - A294
(N1.4) 
 
974/975 Add/update position control budget   
BUDGETED_SALARY56(N7.2)Salary
BUDGETED_BENEFITS65(N7.2)Benefits
BUDGETED_HOURS74(N5.2)Hours