INTEROFFICE MEMORANDUM

TO: Mr. Nathan Maenle, Code BX

FROM: Roy Roebuck, Code UAQ

DATE: 2 April, 2000

SUBJECT: Request for Data Tables

1. Per our previous conversation, request you provide the following data to this office each time you received updated source data from your DBMS source. This data will be used for reference purposes in support of our missions and functions. We require the data in Paradox 3.5 or higher format, in two tables described below.

2. These data fields are from the Combined Systems Download provided to you by DISO-CO-B.

Table 1. Data Element Name, using Table Name Civdata.db.

Agency Code

Activity

Office

Line Number

Creation Date

Allocated Position Grade

Position Service Code

Position Job Title Code

Position Geographic Location Code

Locality Code

Position Military Specialty Code - Primary

Position Military Specialty Code - Secondary

Position Pay Plan

Position Job Series

Academic Discipline

Agency Employment Date

Name, Individual

Entrance on Duty Date

Functional Class

Geographic Location Code

Office Position Title Code

Occupational Series

Office Telephone

Pay Basis

Pay Plan

Position, Official Civilian Title

Position, Title Sort Code

Race and National Origin Identification (RNO)

Sex

Supervisory/NonSupervisory Indicator

Servicing Activity

Work Schedule

Date Entered Present Position

Unit Identification Code

Table 2. Data Element Name, using Table Name Mildata.db.

Military Employee Service Code

Military Employee Designation Code

Military Employee Agency Entrance on Duty Date

Military Employee Detail Activity

Military Employee Detail Office

Military Employee Activity Separation Date

Military Employee Activity Entrance on Duty Date

Military Employee Name

Military Employee Departure Code

Military Employee Sex

Military Employee Work Phone Number

Military Employee Work Room Number

4. I will merge these two files together, resulting in a combined military/civilian table. If you can do this merging, I'll accept the single merged table instead of the two described above.

3. This office is responsible for DISO improvement efforts in the areas of worker diversity, culture, teamwork, and process informing/involving/coordination/collaboration (empowerment), among other things. As such, we do require the ethnic and gender identifiers, as well as their education, specialty, and allocated grade and supervisory status. We on occasion provide consulting services to DISA elements outside DISO, thus requiring all DISA records, as described above. For example, I a currently prototyping a Quality Improvement MIS for the DISA V21/TQM office, who are responding to a tasking from LTG Short for this MIS.

ROY E. ROEBUCK

Organizational Development Specialist

DISTRIBUTION:

CC:

Ms. Mary Eggers, UAQ

Mr. Mike Randall, UTPC

Mr. Walt Okon, AV