Data Mapping
Structure Word Mapping
Data fields from a given change package are mapped into INFO Option change record via Structure Words, or S-words. Not all fields are mapped. There are cases of field truncation, transformation of data for display, and date manipulation.
The list of S-words and their mapping are listed in the following table:
| S-word | INFO Option Interpretation | Change Package Data | Comments | Transformation |
|---|---|---|---|---|
| S0CCF | Change record number | Work request number | 8 zoned numeric digits | right justified, zero filled |
| S0BF0 | Approval status | Entity INFOMGMT approval or rejection | 8 characters left justified | INFO Option values "APPROVED" "REJECTED" "PENDING" blank; interpretation based on first character "A" "R" "P" " " |
| S0B96 | Approval privilege class | n/a | 8 characters left justified | Initially set to \&PRIVCLS; as delivered "CHGMAN" |
| S0BEE | Change record status | n/a | 7 characters left justified | Initially set to "OPEN"; changed to "CLOSED" after package status goes to "BAS" or "TCC" |
| S0C09 | Change type | Level and type | 8 characters left justified | Visual interpretation of package level and type level 1, type 3 means SIM/UP for simple unplanned permanent other literals COM - complex SUP - super PAR - participating /PP - planned permanent /PT - planned temporary /UT - unplanned temporary |
| S0CA5 | System name | Application mnemonic (project) | 8 characters left justified | none |
| S0CBF | Key item affected | Package number | S8 characters left justified | none |
| S0B5C | Coordinator name | Creator TSOID | 8 characters left justified | none |
| S0B59 | Requester name | Creator name | 25 characters left justified | If missing from package, filled with literal "CHANGE/MAN" |
| S0B2D | Requester phone | Creator phone number | 15 characters left justified | none |
| S0C49 | Date required | Install date | 8 characters specially formatted | Package yyyymmdd <===> mm/dd/yyyy on Info/Man |
| S0C72 | Time required | Install (from) time | 5 characters specially formatted | Package hhmm \<===> hh:mm on Info/Man |
| S0E0F | Description | Short title | 72 characters free-form text; required | If missing from package, filled with literal "CHANGE/MAN" |
| S0B9B | Requester department | Department | 4 characters left justified | none |