Conventions for Describing Data Values. Table 3-11 defines the data types used by BCRC for their external interfaces (inbound and outbound). The formatting standard defined for each data type corresponds to the data type identified for each field within the interface layout. This key is provided to assist in understanding the rules behind the formatting of the data values in the layout fields. Table 3-11: Data Type Key. Data Types Used by BCRC for Their External Interfaces (Inbound and Outbound) Data Type/Field Formatting Standard Examples Numeric Zero through 9 (0 to 9) Padded with leading zeroes Numeric (5): “12345” Numeric (5): “00045” Alpha A through Z Left justified Non-populated bytes padded with spaces Alpha (12): “TEST EXAMPLE” Alpha (12): “EXAMPLE “ Alpha-Numeric A through Z (all alpha) + 0 through 9 (all numeric) Left justified Non-populated bytes padded with spaces Alphanum (8): “AB55823D” Alphanum (8): “MM221 “ Text A through Z (all alpha) + 0 through 9 (all numeric) + special characters: Comma (,) Ampersand (&) Space ( ) Dash (-) Period (.) Single quote (‘) Colon (:) Semicolon (;) Number (#) Forward slash (/) At sign (@) Left justified Non-populated bytes padded with spaces Text (8): “AB55823D” Text (8): “XX299Y” Text (18): “XXXXXXX@XXXXXX.XXX” Text (12): “ 000-000-0000” Text (12): “#34” Date Format is field specific Fill with all zeroes if empty (no spaces are permitted) CCYYMMDD (e.g. “19991022”) Open ended date: “00000000” Filler Populate with spaces Populate with spaces Internal Use Populate with spaces Populate with spaces
Conventions for Describing Data Values. The table below defines the data types used by COBC for their external interfaces (inbound and outbound). The formatting standard defined for each data type corresponds to the data type identified for each field within the interface layout. This key is provided to assist in understanding the rules behind the formatting of the data values in the layout fields. Data Type Key Data Type / Field Formatting Standard Examples Numeric • Zero through 9 (0 € 9) • Padded with leading zeroes • Numeric (5): “12345” • Numeric (5): “00045” Alpha • A through Z • Left justified • Non-populated bytes padded with spaces • Alpha (12): “TEST EXAMPLE” • Alpha (12): “EXAMPLE “
Conventions for Describing Data Values. The table below describes the data types used by the COBC for its external interfaces (inbound and outbound). The Formatting Standards used with each data type correspond to the requirements of the interface layout. This key is provided to augment the rules prescribing the formatting of data values that are provided within the PAP Data Exchange Layouts. Data Type Key Data Type / Field Formatting Standard Examples