EEO-4 Detail Report A-448104

Purpose:  Reports EEO function by full time male / female, by Job Category and Salaries.  This report is created for the Division of Human Resources every other odd numbered year (2009, 2011, etc.).
 
FREQUENCY:
Fiscal Year End (odd numbered years only)
CREATED IN:
AU448104
USERS:
DHR
DSP
ONLINE:
Y
SYSID
AUIS44F
AUIS44R
RETENTION
2
1
MICROFICHE:
N
BREAKS:
Gender
EEO Code
TOTALS:
Ethnicity
Gender
 
 
Additional Information:
Exclusions:
·         Educational Agencies EEO Code 3.
·         Appointment Combinations: NEE, NEJ, NEL, NGL, NGB, NRS, NRF, NRG, NRB, & NSB.
 
Job AU448104 does not look at the employee/position records on the database, it looks at monthend dataset AUI.S44.AU445101.EEC48101, so it is using the pay location the position or employee was in when monthend was run.  Also there is special coding in AU448104 to look at the pay locations for agency 270 on the ORG directory.  It looks only at the main agency record (no pay location) on the ORG directory for all other agencies.
 
Control Card Instructions:
 
1ST LINE
 
Columns
 
From
To
FUNC
Instructions
01
03
A
3 DIGIT AGENCY CODE OR ALL - ALL IS THE DEFAULT (CONSTANT)
04
05
S
SKIP - BLANK FILLED
06
09
N
YYYY = 4 DIGIT FISCAL YEAR
10
11
S
SKIP - BLANK FILLED
12
19
N
16100000 = STATE ID NUMBER (CONSTANT)
20
80
S
SKIP - BLANK FILLED
 
 
2ND LINE
 
Columns
 
From
To
FUNC
Instructions
01
20
A
CONTACT PERSON FIRST & LAST NAME (CONSTANT) USE SPACES AS NEEDED, UP TO COLUMN 20
21
35
S
SKIP - BLANK FILLED
36
55
A
CONTACT PERSON TITLE (CONSTANT) USE SPACES AS NEEDED, UP TO COLUMN 55
56
80
S
SKIP - BLANK FILLED
 
 
3RD LINE
 
Columns
 
From
To
FUNC
Instructions
01
20
A/N
STREET ADDRESS OFCONTACT PERSON (CONSTANT) USE SPACES AS NEEDED, UP TO COLUMN 20
21
35
S
SKIP - BLANK FILLED
36
55
N
PHONE NUMBER OF CONTACT PERSON (CONSTANT)
56
80
S
SKIP - BLANK FILLED
 
 
4TH LINE
 
Columns
 
From
To
FUNC
Instructions
01
20
A/N
CITY, STATE & ZIP CODE OF CONTACT PERSON (CONSTANT)
21
80
S
SKIP - BLANK FILLED
 
 
5TH LINE
 
Columns
 
From
To
FUNC
Instructions
01
20
A
AUTHORIZED OFFICIALS NAME (CONSTANT)
21
35
S
SKIP - BLANK FILLED
36
60
A
AUTHORIZE OFFICIALS TITLE (CONSTANT)
61
80
S
SKIP - BLANK FILLED
 
 
Example: