Figure 1. Example of data record format.

+----------------------------------------------------------+	
|                   Format of Data Record                  |	
|  ------------------------------------------------------  |	
|                                   RANGE OF      UNIT OF  |	
|   ITEM NAME        FORMAT          VALUES     MEASUREMENT|	
|  ------------------------------------------------------  |	
|   ORG-NAME         30   AN        1-9,A-Z                |	
|   ORG-ID            6   AN        1-9,A-Z                |	
|   SOC-SEC-NO        9    N           0-9                 |	
|   NAME             20   AN              -                |	
|   PAY-GRADE         4   AN              -                |	
|   GROSS-PAY         6   SN           0-9        Dollars  |	
|   GROSS-PAY-YTD     8   SN           0-9        Dollars  |	
|   FED-TAX           6   SN           0-9        Dollars  |	
|   FED-TAX-YTD       8   SN           0-9        Dollars  |	
|   FICA              6   SN           0-9        Dollars  |	
|   FICA-YTD          8   SN           0-9        Dollars  |	
|   STATE-TAX         6   SN           0-9        Dollars  |	
|   STATE-TAX-YTD     8   SN           0-9        Dollars  |	
|   STATE-TAX-CODE    2   AN          B3-F6                |	
|   ALLOTMENTS        6   SN           0-9        Dollars  |	
|   NET-PAY           6   SN           0-9        Dollars  |	
|                                                          |	
|                                                          |	
|   AN = Alphanumeric                                      |	
|   SN  = Signed Numeric                                   |	
|                                                          |	
+----------------------------------------------------------+

Figure 2. Example of preprogrammed query capability.

+----------------------------------------------------------+	
|               Preprogrammed Query Capabilities           |	
|  ------------------------------------------------------  |	
| DESCRIPTION                                    QUERY CODE|	
|  ------------------------------------------------------  |	
|                                                          |	
| Number of employees within an organization          A    |	
| Number of employees in a specific pay grade         B    |	
| Total gross pay for employees within an             C    |	
|   organization                                           |	
| State tax year-to-date for specific state           D    |	
| FICA tax year-to-date for a specific employee       E    |	
| Total deductions for a specific employee            F    |	
| Net pay for a specific employee                     G    |	
+----------------------------------------------------------+

Figure 3. Example of query format.

+----------------------------------------------------------+	
|                     Format of Query A                    |	
|                                                          |	
|  ------------------------------------------------------  |	
|                                                          |	
|        NUMBER OF EMPLOYEES WITHIN AN ORGANIZATION        |	
|  ------------------------------------------------------  |	
|                                                          |	
|   QUERY ITEM            CHARACTER         CONTENT/       |	
|     TITLE               POSITION          COMMENT        |	
|                                                          |	
|  Query Designator           1       Q   Constant         |	
|  File Number               2-3     01   Constant         |	
|  Query Number              4-5          Insert 01-99     |	
|  Security Classification   10       U   Unclassified     |	
|  Query Card Format Code    12       A                    |	
|  Organization             14-19         Insert ORG-ID    |	
|                                         as requested by  |	
|                                         query.  Refer to |	
|                                         data format for  |	
|                                         applicable code. |	
|                                                          |	
+----------------------------------------------------------+

Figure 4. Example of query statement.

+----------------------------------------------------------+	
|                                                          |	
|                   Query Statement                        |	
|  ------------------------------------------------------  |	
|                                                          |	
| Request - No. of employees within an organization        |	
|           (Office of Secretary of Defense)               |	
|                                                          |	
| Query Statement - IF ORG-ID EQ OSD LIST NO OF EMPLOYEES  |	
+----------------------------------------------------------+

Translator: Simon Wright simon@pogner.demon.co.uk
Last updated: 22.iii.99