Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

PPS Requirements New Veteran Status Code

VIEWS: 9 PAGES: 23

									PPS Requirements: New Veteran Status Code
Service Request 15123
04/14/00


Background

New federal reporting requirements for the U.S. Department of Labor mandate the collection of
information on employees "…who served on active duty during a war or in a campaign or expedition for
which a campaign badge has been authorized." This new category is separate from the existing
Vietnam Era Veteran and Special Disabled Veterans categories on which the University already
collects data and reports to the Department of Labor. An individual employee may identify him/herself
as included in this new category in addition to either of the other two categories already identified.


Payroll/Personnel System Modifications

New EDB Data Element

To comply with the new reporting regulations for veterans, a new data element, the
War/Campaign/Expedition Veteran Status Code, will be established on the Employee Data Base
(EDB). A value of 'E' will indicate the employee participated in an eligible war or campaign or
expedition. A value of blank or 'N' will indicate the employee did is not a veteran in this category.

The existing data element EDB 0350, Veteran Status Code, should be renamed Vietnam Era Veteran
Status Code to avoid any confusion that might be caused by the current 'generic' name.

Attachment A contains a draft data dictionary page for the new data element and a revision for data
element EDB 0350.


New History Data Element

The new War/Campaign/Expedition Veteran Status data element should be added to the History Data
Base (HDB). It should be captured for history in the normal process using the Employee Change File
(ECF).


EDB Maintenance

Range/value edits should be provided to prohibit any value other than 'E', 'N', or blank from being
entered in this new data element.

The new War/Campaign/Expedition Veteran Status Code should be made legal to enter in position 23
of the 'ED' transaction for batch EDB Maintenance processing.




                                                                                                        1
On-line Screens and On-line Help

Note: Changes to the IPER EDB Inquiry screen and EPD1 EDB Entry/Update screen have been
requested in Service Request 14838, which specifies PPS modifications to provide an expanded
campus address for employees. These requirements use the version of EPD1 defined in that
service request, and add the new data element to that revised version.

The new data element should be added to the IGEN and EPD1 CICS on-line screens for inquiry and
entry/update. Because the IGEN screen has no available space, it is suggested that the two existing
labels 'Veteran Status' and 'Vet Disab Stat' be eliminated. In their place, a group field label should be
provided for the three Veteran Status Codes. The data would therefore be presented in the order
Vietnam Era Veteran Status Code, War/Campaign/Expedition Veteran Status Code, and Veteran
Disability Status Code (Special Disabled Veteran), as follows:

Veteran Status: V/E/S

The new data element should also be added to the IBA2 History Inquiry screen (and corresponding
UBA2 screen). This screen currently has no available space for the new data element. It is suggested
that the existing veteran status field labels 'Veteran Status' and 'Veteran Disability' be combined in a
manner similar to IGEN. The group field label would be 'Veteran Status Cds'. The data would
therefore be presented as follows:

Veteran Status Cds: V/E/S

The new data element should also be added to the HPER Personal Data History screen. Because of
space limitations, it is suggested that the two existing veteran status code fields and the new data
element be combined into a group field. The data would therefore be presented as follows:

Veteran Status: V/E/S

In addition, the field label HDCP should be renamed to Disabled Status and moved below the field label
Veteran Status, to conform to the requirements in Service Request 14837. The field label 'Campus
Addr' and the associated data should be removed from the screen to conform to the requirements in
Service Request 14838.

Attachment B contains screen samples showing the suggested placement of the new element on the
screens.

On-line field level help, based on the data dictionary entry, should be provided for the new data element
on each screen to which it is added. On the IGEN and IBA2 screens, a group field level help must be
developed for the new group label. This group help should provide access to the individual help for the
three veteran status data elements. Because the three veteran status data elements are being
combined into a group field on the IGEN screen, screen-level help for IGEN should also be modified to
reflect the new group field.

Attachment C provides the group label field level help for the Veteran Status Codes and the
modifications to the screen level help for IGEN, EPD1, IBA2/UBA2, and HPER.




                                                                                                            2
Forms

Form U5605 is used for the collection of the existing Veteran Status information. This form will be
modified to accommodate the entry of the new War/Campaign/Expedition Veteran Status Code. This
modification is being coordinated by the Employee Relations & EEO/AA/Diversity Office at Office of the
President. Campuses will be notified when it is available.

Form UPAY640A, the Payroll Maintenance Worksheet -1, will also be modified to reflect the new field
on the 'ED' transaction.


Reports

Report PPP8612, "Layoff Administration Affirmative Action Adverse Impact Report" should be modified
to include the new War/Campaign/Expedition Veteran Status Code on the report.

Attachment D contains a report sample showing the label and position for the new data element. In
addition, the title for “Vet Stat” should be changed to “Vet Viet Stat”.


CPS Interface File

The new War/Campaign/Expedition Veteran Status Code should be added to the Employee Record of
the Corporate Personnel System Interface file. Existing 'Filler' space on the record will be used, so the
record length will not change.

Attachment E contains the revised layout for the CPS Interface Employee Record, with the new data
element included in position 369. In addition, the field description for “Veteran Status Code” located in
position 370, should be changed to “Vietnam Era Veteran Status Code”.




                                                                                                            3
                                        Sample data dictionary page for
                           War/Campaign/Expedition Veteran Status Code


System Number:            EDBxxxx

User Access Name:

Programming Name:

Revision Date:

Edit Requirement:

Comments:

Source(s):
Use(s):
Location(s):

Name:                     WAR/CAMPAIGN/EXPEDITION VETERAN STATUS CODE

Type:                     ALPHANUMERIC

Length:                   1

Format:

N/A

General Description:

Code indicating whether an individual who is a veteran has served on active duty during a war
or in a campaign or expedition for which a campaign badge has been authorized.

Code Interpretation:

        Blank – Not a War/Campaign/Expedition veteran
        N     – Not a War/Campaign/Expedition veteran
        E     – War/Campaign/Expedition veteran




                                                                                  Page      1
                                                                                 Attachment A
                                                                    Veteran Status Code Reqts
                                                         Modified EDB0350 sample

System Number:                    EDB0350

User Access Name:                 0350-4

Programming Name:

Revision Date:                    04/01/00

Edit Requirement:

Comments:

Source(s):     BAS 1050 - Veteran Status Code – BAS in HDB
               APS 2799 - Veteran Status Code
               CPS 2799 - Veteran Status Code
               IPS 2799 - Veteran Status Code
               OPP 2799 - Veteran Status Code
               APS 3017 - Veteran Status Code (Input) (Coding is different)
               CPS 3017 - Veteran Status Code (Input) (Coding is different)
               IPS 3017 - Veteran Status Code (Input) (Coding is different)
               OPP 3017 - Veteran Status Code (Input) (Coding is different)
Use(s):
Location(s):

Name:          VIETNAM ERA VETERAN STATUS CODE

Type:          ALPHANUMERIC

Length:        1

Format:

N/A

General Description:

Code indicating whether an individual is a Vietnam Era Veteran.

Code Interpretation:

Blank          - Not a Vietnam Era Veteran
N              - Not a Vietnam Era Veteran
V              - Vietnam Era Veteran
                                                                                   Page      2
                                                                                  Attachment A
                                                                     Veteran Status Code Reqts
                                                                               Sample IGEN Screen


    PPIGEN0-I1197                     EDB Inquiry                  03/29/00 09:54:36
    03/20/00 11:16:11           General Information 1              Userid: PAYPCW
    ID: 000050001 Name: HIGHWATER,HELEN             SSN: 552-14-2012
    Hm Dept: 804918 CHAN OFFICE      Emplmt Status: A Pri Pay: MO

  Gen No        :        0005        Date of Hire       : 07/01/82 Lst Day on Pay:
  Date of Birth :        02/01/35    Citizen            : C        Separation    :
  Sex           :        F           Visa Type          :          Sep Rsn/Dest :
  Ethnic ID     :        A           Work Perm End Date :          Antcptd Ret Dt:
1
 Veteran Status:         V/E/S       U.S. Date of Entry :          LOA Beg       :
2
                                     I-9 Date           :          LOA Return    :
    Disab Status     :   N           Oath Signature Date: 07/01/82 LOA Type      :
    Stdt St/Units    :   1/          PIN Signature Date : 04/01/97 Nx Sal Rev    :                      07/93
    UI Code          :   C           Fed Tx Marit/Allw : M 015     Nx Sal Rev Typ:                      2
    Retirement       :   U           Fed Tax Max        :   999    EREL/ERL/EUC :                       A/99/A3
    FICA Elig Cd     :   E           Calif Tx Marit/Pers: M 003    EREP/ESH/EDUC :                      U/ /
    Asgn/Drv BELI    :   1/1         Calif Tx Item      :   012 Other St Name    :
    Pay Disp         :   8           Calif Max          :   999 Other St CA Res :
    APUC             :               Pr ID:             Pr Name:
    Next Func:           ID:              Name:                             SSN:

    ===>
     F: 1-Help            2-Browse         3-PrevMenu       4-Print
     F:                                    9-MainMenu                                        12-Exit




1
  After the field label for “Veteran Status” display data for “Vietnam Era Veteran Status Code”, War/Campaign/Expedition
Veteran Status Code” and “Veteran Disability Status Code”.
2
  Remove the field label and data for “Vet Disab Stat”.




                                                                                                          Page 1
                                                                                                      Attachment B
                                                                                         Veteran Status Code Reqts
                                                                                Sample EPD1 Screen


 PPEPD10-E0964                       EDB Entry/Update                12/21/99
08:50:39
 06/17/97 14:37:54         Employee Personal Data - 1          Userid: PAYUSR1
 ID: 000050021 Name: BLUES,BERTHA D.            SSN: 555-55-5021 Pri Pay: BW

  Date of Birth: 101937
  Sex: F
  Ethnic: 5
1
 Veteran Status Codes – Vietnam: N War/Campaign: N Disability: N
2
 Disabled Status: H
  Citizenship: C
  Student Status: 1 No. of Reg. Units:




    ===>
     F: 1-Help                             3-PrevMenu        4-Print          5-Update
     F:                                        9-Jump                                               12-Exit




1
 Insert new field label “Veteran Status Codes” and field label and data for “Vietnam”, “War/Campaign” and “Disability”.
2
 Remove the field label and data for “Veteran” and “Veteran Disability” leaving the field label and data for “Disabled
Status”.
                                                                                                          Page    2
                                                                                                       Attachment B
                                                                                          Veteran Status Code Reqts
                                                                       Sample UBA2/IBA2 Screen


    PPIBA20-I1197                   History Inquiry                 03/29/00 10:22:46
    07/16/96 14:24:00          Basic Employment Data 2              Userid: PAYPCW
    ID: 000050001 Name: HIGHWATER,HELEN             SSN: 552-14-2011
    Incorrect Flag :
                                                    1
    Birth Date     : 02/01/1935
                                                    2
    Sex            : F                               Veteran Status Cds: V/E/S
                                                    3
    Ethnic Origin : A                                Disabled Status     : N
    Citizen Status : C                                Visa Type          :
    Education Level: D                                Work Perm End Date:
    Education Year : 60                               U.S. Date of Entry:
    Highest Degree :       Date:                      UC Student Status : 1
    Degree Field   :       Inst:                      Curr. Specialty-1 :
    Foreign Address:                                                  -2 :
    Permanent Addr : 2440 FILLMORE STREET                             -3 :
                                                      Future Institution:
    Permanent City : SAN FRANCISCO                    Trip Begin Date    :
    Permanent State: CA Zip: 94115                    Trip Duration      :
    Foreign Country:     Province:                    Trip %             :
    Next Func:       ID:           Name:                              SSN:
         Date:         View incorrect records?

    ===>
     F: 1-Help             2-Browse          3-PrevMenu 4-Print
     F:                                      9-MainMenu 10-PrevRec                                12-Exit




1
  Remove the field label and data for “Veteran Status”.
2
  Remove the field label and data for “Veteran Disability” and replace with the label “Veteran Status Cds”. After this label,
display the data for “Vietnam Era Veteran Status Code”, “War/Campaign/Expedition Veteran Status code” and “Veteran
Disability Status Code”.
3
  Change the field label “Handicapped Status” to “Disabled Status”.
                                                                                                             Page    3
                                                                                                          Attachment B
                                                                                             Veteran Status Code Reqts
                                                                                  Sample HPER Screen


  PPHPER0-I1109                 History Reporting                 03/29/00 10:27:14
  Last Update: 02/14/00       Personal Data History               Userid: PAYPCW
  ID: 000050001 Name: HIGHWATER,HELEN              SSN: 552-14-2011      PG 01 OF 03
1
 Hm Dept: 804918                               Status: Active              ITR: 001
  Most Recent Hire : 07/01/82     Prob Per End Dt:            Sep Dt :
  Original Hire    :              Emp Ser Credit : 186        Last Day:
  Oath Signature Dt: 07/01/82               From : 07/82      Sep Rea :
  I-9 Date         :              Prior UC/ST Service:        EREP/ESH/EDUC: U/ /
  Citizen: C Visa :               BELI: 1 02/01/91            EREL/EUC: A/A3
  Student Status   : 1            Ret/FICA       : U/E
  Sex: F   Ethnic : A             Ret FICA Derive:            Educ Level     : D
2
 Veteran Status    : V/E/S       Date Of Birth : 02/01/35     Educ Level Yr : 60
3
 Disabled Status : N
  Primary Title: 0001 PRESIDENT OF THE UNIVERSITY
  Job Group ID : M05 EXECUTIVES
                                             4
  Perm Addr: 2440 FILLMORE STREET             Campus Addr: UCSF CED     400

                  SAN FRANCISCO          CA 94115
    Next Func:         ID:            Name:                            SSN:
    As Of Date:            Past To Present:    View Incorrect Records:

    ===>
     F: 1-Help             2-Browse          3-PrevMenu        4-Print
     F:                    8-Forward         9-MainMenu                                          12-Exit




1
  Remove blank line and move data up.
2
  Remove the field label and data for “Veteran Disability” and replace with the label “Veteran Status”. After this label,
display the data for “Vietnam Era Veteran Status Code”, “War/Campaign/Expedition Veteran Status code” and “Veteran
Disability Status Code”.
3
  Move existing field label and data “Disabled Status”.
4
  Remove field label and data for “Campus Addr”.




                                                                                                            Page    4
                                                                                                         Attachment B
                                                                                            Veteran Status Code Reqts
                                                   Sample Help Text for EDB0350G


EDB0350G       Veterans Status Codes
                                                      More:
Description: This group field refers to the three data elements
shown below:
              1 -- #0350 – Vietnam Era Veteran Status Code
              2 -- #New DE – War/Campaign/Expedition Veteran Status Code
              3 -- #0351 – Veteran Disability Status Code

Place the cursor on the number of the data element for which
help is desired and press F1.
Command ===>
F1=Help F2=EX help F3=eXit F4=copy F6=move
F7=BKwd F8=FWd F12=Cancel




                                                                                     Page    1
                                                                                  Attachment C
                                                                     Veteran Status Code Reqts
                                          Sample screen level help text for IGEN

            EDBHIGEN              Help EDB General-Info-1
                                          More: +
     Function: IGEN allows the user to view information relating
     to the employee as an individual rather than to the
     appointment(s) held by the employee, or to the distribution(s)
     related to those appointment(s).

     Nature of Information: The employee is identified by Iden-
     tification Number (ID), Name, and Social Security Number
     (SSN). ID and SSN are unique to the individual.

     Translations for the following highly abbreviated data fields
     appear below:
       Asgn BELI - Benefits Eligibility Level Indicator-Assigned
       Drv BELI - Benefits Eligibility Level Indicator-Derived
       Antcptd Ret Dt - Anticipated Retirement Date
       Disab Status – Disabled Status
        EREL - Employee Relations Code
        EREP - Employee Representation Code
        ESH - Employee Special Handling Code
        EDUC - Employee Distribution Unit Code
        LOA Beg - Leave of Absence-Begin Date
        LOA Return - Leave of Absence-Return Date
        LOA Type - Leave of Absence Type Code
        Pr ID - Previous Identification Number
        Pr Name - Name-Employee-Prior
        Pri Pay - Deduction Pay Schedule Code
        UI Code - Unemployment Insurance Coverage Code

    The following are group labels displayed on this screen:
       Assgn/Drv BELI
       Fed Tx Marit/Allw
       State Tx Marit/Pers
       Separation Rsn/Dest
      EREL/EUC
      EREP/ESH/EDUC
      Veteran Status

Command ===>
    F1=Help F2=EX help F3=eXit F4=copy F6=move F7=BKwd F8=FWd
    F12=Cancel




                                                                                      Page    2
                                                                                   Attachment C
                                                                      Veteran Status Code Reqts
                                         Sample screen level help for EPD1
       EDBHEPD1              Help EDB E U Personal Data 1
                                   More:
Function: EPD1 enables the user to enter and update
personal information about the employee.

 Nature of Information: EPD1 contains personal
demographic information such as employee birthdate,
sex, ethnicity, veterans status, and student status.

The following are group labels displayed on EPD:

Veteran Status Codes

There are no highly abbreviated fields on EPD1.

Command ===> .
    F1=Help F2=EX help F3=eXit F4=copy F6=move F7=BKwd F8=FWd
    F12=Cancel




                                                                            Page    3
                                                                         Attachment C
                                                            Veteran Status Code Reqts
                                Sample screen level help for IBA2/UBA2

       HDBHXBA2                  Basic Employment Data-2
                                          More: +
 Function: IBA2 is presented when the user requests either the
 IBA2 or the UBA2 function. IBA2 enables the user to view the
second of two screens displaying general historical data for an
employee, one historical entry per screen. (Function code IBA1
displays the other general historical data.) The user can
scroll through any other occurrences of the second group of
basic employment data entries for the employee by using the F10
and F11 keys.
    The user can view historical records for a specific entry
date by entering that date in the field labeled 'Date:' in the
footer. If the user leaves the 'Date:' field blank, the record
with the most recent date will be displayed first.
    The user can avoid viewing records flagged as incorrect
by entering "N" in the field labeled "View Incorrect Records?".
A "Y" entered in the field will retrieve both correct and
incorrect records.
   The user may update the "Incorrect Flag" field to change
the designation from "correct" to "incorrect" by entering an
 "X" in the field. If the Incorrect Flag field is set to X,
the user may change the designation from "incorrect" to "cor-
rect" by entering a "*" in the Incorrect Flag field, which will
reset the field to blank.

Nature of Information: IBA2 (UBA2) displays information about
the employee as an individual including birth date, sex,
ethnicity, citizenship, educational background, address,
veteran/handicapped/student status, and temporary reductions
 in time.

The following are group labels displayed on IBA2/UBA2:

Veteran Status Cds

There are no highly abbreviated fields on IBA2 (UBA2).

Command ===>
    F1=Help F2=EX help F3=eXit F4=copy F6=move F7=BKwd F8=FWd
    F12=Cancel




                                                                                  Page    4
                                                                               Attachment C
                                                                  Veteran Status Code Reqts
                                           Sample screen level help for HPER

       HDBHHPER            Help HDB Personal Data History
                                  More: +
Function: HPER displays various personal data for an
employee.

Nature of Information: A change to any of the following
elements will result in a new Personal Data screen being
displayed:

  Most Recent Hire Date
  Original Hire Date
  Oath Signature Date
  I-9 Date
  Citizenship Status Code
  Visa Status Code
  Student Status
  BELI
  BELI Effective Date
  Retirement Code
  OASDI/MEDICARE Code
  Separation Date
  Last Day on Pay Status
  Separation Reason
  Employee Representation Code (EREP)
  Employee Special Handling Code (ESH)
  Employee Distribution Unit Code (EDUC)
  Employee Relations Code (ERC)
  Employee Unit Code (EUC)

The remaining fields on this screen will be displayed at the
point in time of the field change which has caused a new
screen to be displayed.

The following are group labels displayed on HPER:

Veteran Status

Translations for the following highly abbreviated data fields
appear below:

EREL - Employee Relations Code
EREP - Employee Representation Code
ESH - Employee Special Handling Code
EDUC - Employee Distribution Unit Code
Prob Per End Dt - Probationary Personnel End Date
Emp Ser Credit - Employee Service Credit
Sep Dt - Separation Date
                                                                                Page    5
                                                                             Attachment C
                                                                Veteran Status Code Reqts
Sep Rea - Separation Reason
BELI – Benefits Eligibility Indicator

The information contained on this screen will usually be
displayed with the most recent information on the first
screen. To see prior information, the user must scroll
"forward" to additional screens in the group.

Translations for the following fields are provided:

  Primary Title Code - From the Title Code Table
  Job Group Identifier - From the Job Group Identifier Table

Command ===>
    F1=Help F2=EX help F3=eXit F4=copy F6=move F7=BKwd F8=FWd
    F12=Cancel




                                                                               Page    6
                                                                            Attachment C
                                                               Veteran Status Code Reqts
PPP8612/PPP861                                          UNIVERSITY OF CALIFORNIA-SYSTEMWIDE                                      PAGE NO.     0001
RETN: SEE RPTS DISP SCHEDULE/DIST.                            DATABASE MAINTENANCE                                               RUN DATE 04/12/00
                                                             LAYOFF ADMINISTRATION
                                                      AFFIRMATIVE ACTION ADVERSE IMPACT REPORT

LAYOFF UNIT CODE: B200          UNIT B200                       TITLE CODE: 4722     ______ASSISTANT III
                                                                                                                          1
                                                              LAYOFF    APPT     APPT            %                DIS      VETERAN STATUS ETH
            NAME                    EMP ID      HIRE DATE   SENIORITY   DEPT     TYPE    TUC   TIME   SEX   AGE   STAT   VIETNAM WAR/CAMP ID

ANDERSON, JOHN Q                   999888020    03/01/99      168.00    861001   2       CX    1.00   M     38    N        N        N      E
BOTTLEMAN, WILLIAM THOMAS          354666890    03/30/96                861001   2       CX    1.00   M     59    Y        Y        Y      5
CAPLES, JONATHAN DOUGLAS           456378999    08/12/89      168.00    861001   2       CX    1.00   M     64    N        Y        Y      A
DONALD, HARRIET P                  398645552    11/03/79      172.00    861001   2       CX    1.00   F     44    N        N        N      E




1
    Change the existing label as highlighted.


                                                                                                                                               Page    1   1e 1ag
                                                                                                                                            Attachment D
                                                                                                                               Veteran Status Code Reqts
                                                      Modified FCP/BCS Record Layout



      Positions                        Field Description                    Comments


1–2               Location

3 – 11            Employee Identification Number

12 – 46           Employee Name                                   EDB0105

47 – 76           Address Permanent Line One                      EDB0204

77 – 106          Address Permanent Line Two                      EDB0205

107 – 127         Address Permanent City                          EDB0206

128 – 129         Address Permanent State                         EDB0207

130 – 134         Address Permanent ZIP                           EDB0208

135 – 139         Filler
140               Home Address Disclosure Indicator               EDB0211

141 – 149         Social Security Number                          EDB0111

150               Sex Code                                        EDB0108

151 – 156         Date of Birth                                   EDB0107 (YYMMDD)

157               Citizenship Status Code                         EDB0109

158 – 159         Ethnic Origin Code                              EDB0112

160               Retirement System Code                          EDB0122

161               FICA Eligibility Code                           EDB0120

162               Unemployment Insurance Coverage Code            EDB0121

163               UC Student Status Code                          EDB0119

164 – 172         Previous ID Number




                                                                                      Page 1
                                                                                Attachment E
                                                                   Veteran Status Code Reqts
      Positions                       Field Description                  Comments


173 – 175         Prior Service Credit Months              EDB0146

176 – 177         Filler

178 – 193         Organization Code

194               Position Type Code

195               Confidential Information Code

196 – 201         Most Recent Hire Date                    EDB0113 (YYMMDD)

202 – 205         Next Salary Review                       EDB0136 (YYMM)

206               Next Salary Review Type                  EDB0135

207               Employment Status Code                   EDB0144

208 – 209         Filler

210 – 213         Merit Percent                            EDB0153
214 – 219         Separation Date                          EDB0140 (YYMMDD)

220 – 221         Separation Reason Code                   EDB0141

222 – 227         Leave of Absence Begin Date              EDB0137 (YYMMDD)

228 – 233         Leave of Absence Return Date             EDB0138 (YYMMDD)

234 – 235         Leave of Absence Type Code               EDB0139

236               DCP Plan Code                            EDB0129

237 – 240         Sick Leave Used                          Zero Filled

241 – 245         Sick Leave Hours Balance (Current)       EDB5186

246               Filler

247 – 249         Vacation Used                            Zero Filled

250 – 252         Vacation Leave Hours Balance (Current)   EDB5185

253 – 256         Vacation Lost                            Zero Filled

257 – 259         Compensation Time Used                   Zero Filled




                                                                                Page 2
                                                                          Attachment E
                                                             Veteran Status Code Reqts
      Positions                     Field Description                              Comments


260 – 263         Compensatory Time Hours Balance (Current)          EDB5110

264 – 268         Overtime Paid                                      Zero Filled

269 – 273         Overtime Worked                                    Zero Filled

274 – 279         Overtime Hours Worked YTD                          EDB5103

280               Month Pay Indicator-January                        EDB0171

281               Month Pay Indicator-February                       EDB0172

282               Month Pay Indicator-March                          EDB0173

283               Month Pay Indicator-April                          EDB0174

284               Month Pay Indicator-May                            EDB0175

285               Month Pay Indicator-June                           EDB0176

286               Month Pay Indicator-July                           EDB0177
287               Month Pay Indicator-August                         EDB0178

288               Month Pay Indicator-September                      EDB0179

289               Monthly Pay Indicator-October                      EDB0180

290               Monthly Pay Indicator-November                     EDB0181

291               Monthly Pay Indicator-December                     EDB0182

292 – 297         Accidental Death and Dismemberment Coverage        EDB0282 (YYMMDD)
                  Effective Date

298               Accidental Death and Dismemberment Coverage Code   EDB0281

299 – 301         Accidental Death and Dismemberment Principal Sum   EDB0280

302 – 307         Dental Plan Coverage Effective Date                EDB0274 (YYMMDD)

308 – 309         Filler

310 – 315         Life Insurance Coverage Effective Date             EDB0277 (YYMMDD)

316               Life Insurance Plan Code                           EDB0276




                                                                                          Page 3
                                                                                    Attachment E
                                                                       Veteran Status Code Reqts
      Positions                       Field Description                          Comments


317 – 319         Life Insurance Salary Base                           EDB0275

320               Dependent Life Insurance Plan Code                   EDB0278

321 – 326         Medical Plan Coverage Effective Date                 EDB0294 (YYMMDD)

327 – 328         Medical Plan Code                                    EDB0292

329               Filler

330 – 332         Medical Plan Coverage Code                           EDB0293

333 – 340         Filler

341               Filler

342 – 343         Filler

344 – 345         Primary BELI Status Qualification Code               EDB0240

346 – 351         Primary BELI Status Qualification Effective Date     EDB0241 (YYMMDD)
352 – 353         Secondary BELI Status Qualification Code             EDB0242

354 – 359         Secondary BELI Status Qualification Effective Date   EDB0243 (YYMMDD)

360               UC Paid Temporary Disability Insurance Code          EDB0123

361 – 368         Filler

369               War/Campaign/Expedition Veteran Status Code          New Data Element

370               Vietnam Era Veterans Status Code                     EDB0350

371               Veteran Disability Status Code                       EDB0351

372               Handicapped Status Code                              EDB0352

373               Insurance Reduction Code                             EDB0299

374 – 375         Employee Unit Code                                   EDB0255

376               Employee Special Handling Code                       EDB0256

377               Employee Distribution Unit Code                      EDB0257

378               Employee Representation Code                         EDB0295




                                                                                           Page 4
                                                                                     Attachment E
                                                                        Veteran Status Code Reqts
      Positions                      Field Description                            Comments


379 – 390         Filler

391               Depcare Participation

392 – 399         Filler

400               FCP Select Flag

401 – 402         Dental Plan Code                                      EDB0272

403 – 405         Dental Coverage Code                                  EDB0273

406               Federal Tax Marital Status Code                       EDB0127

407               State Tax Marital Status Code                         EDB0130

408               Filler

409 – 414         Vision Plan Coverage Effective Date                   EDB0349 (YYMMDD)

415 – 416         Vision Plan Code                                      EDB0347
417 – 419         Vision Plan Coverage Code                             EDB0348

420 – 422         Filler

423               Filler

424 – 426         Life Insurance-UC Paid                                EDB0330

427               UCRS Short Loan

428               UCRS Long Loan

429 – 430         Legal Plan Code                                       EDB0353

431 – 433         Legal Plan Coverage Code                              EDB0354

434 – 439         Legal Plan Coverage Effective Date                    EDB0355 (YYMMDD)

440 – 442         Federal Tax Withholding Allowances                    EDB0128

443 – 445         State Tax Personal Withholding Allowances             EDB0131

446 – 448         State Tax Itemized Deduction Withholding Allowances   EDB0132

449               Executive Life Insurance Indicator                    EDB0356




                                                                                            Page 5
                                                                                      Attachment E
                                                                         Veteran Status Code Reqts
      Positions                           Field Description                      Comments


450 – 452         Executive Life Insurance Salary Base                 EDB0357

453               Benefits Eligibility Level Indicator                 EDB0360

454               Benefits Eligibility Level Indicator Derived         EDB0375

455 – 458         Benefits Eligibility Level indicator Conflict Date   EDB0376 (YYMMDD)

459               Medical Insurance Opt Out Code                       EDB0377

460               Dental Insurance Opt Out Code                        EDB0378

461               Vision insurance Opt Out Code                        EDB0379

462 – 465         Average Hours Worked Per Week                        EDB5132

466 – 471         Dependent Life Coverage Effective Date               EDB0188 (YYMMDD)

472 – 480         Total Gross YTD                                      EDB5501

481 – 489         Federal Withholding Tax Gross YTD                    EDB5502
490 – 498         YTD Depcare Deduction                                EDB6225Y

499 – 507         Filler

508 – 516         Filler

517 – 522         Last Day On Pay Status                               EDB0189

523 – 531         SPP-Total Interest-Sr Mgt                            EDB0409

532 – 540         SPP-Total Contribution-Interest Posted- Sr Mgt       EDB0402

541 – 546         SPP-Changed Date- Sr Mgt                             EDB0411 (YYMMDD)

547 – 555         SPP-X Month Contribution-No Interest- Sr Mgt         EDB0403 – EDB0408 (1st – 6th
                                                                       Month)
                  Where X = 1st , 2nd , 3rd, 4th , 5th , or 6th

556 – 564         SPP Current Month Contribution

565 – 573         SPP-Total Interest-HS                                EDB0439

574 – 582         SPP-Total Contribution-Interest Posted-HS            EDB0432

583 – 588         SPP-Changed Date-HS                                  EDB0441 (YYMMDD)




                                                                                           Page 6
                                                                                     Attachment E
                                                                        Veteran Status Code Reqts
      Positions                           Field Description                    Comments


589 – 597         SPP-X Month Contribution-No Interest-HS            EDB0433 – EDB0438 (1st – 6th
                                                                     Month)
                  Where X = 1st , 2nd , 3rd, 4th , 5th , or 6th

598 - 606         HSPP Current Month Contribution

607               EPD Insurance Plan Code

608 – 610         Employee Paid Disability Waiting Period            EDB0231

611 – 615         Employee Paid Disability Salary Base               EDB0232

616 – 621         Employee Paid Disability Coverage Effective Date   EDB0233 (YYMMDD)

622 – 625         Primary Title Code                                 EDB0460

626 – 637         Filler

638 – 643         UCTD Insurance Plan Coverage Effective Date        EDB0453 (YYMMDD)

644 – 652         Federal Withholding Tax Gross - FYTD               EDB5545
653 – 660         Filler




                                                                                         Page 7
                                                                                   Attachment E
                                                                      Veteran Status Code Reqts

								
To top