Definition of table carrier-route
Carrier Route definitions , Table Dump Name car-root

Alphabetical Field Summary

  • carrier-route: (CHAR) Carrier route #/code (assigned by USPS)
  • carrier-route-id: (INTG) Internally assigned ID value for carrier route [DEFINE KEY]
  • city: (CHAR) City for this carrier route
  • county-code: (CHAR) State County Code (optional)
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • external-code-1: (CHAR) Code to map to an external system
  • external-code-2: (CHAR) Code to map to an external system
  • external-code-3: (CHAR) Code to map to an external system
  • external-code-4: (CHAR) Code to map to an external system
  • external-code-5: (CHAR) Code to map to an external system
  • locality-code: (CHAR) Code for this locality/township/city/village
  • locality-precinct: (CHAR) Precinct for this locality/township/city/village
  • school-district-code: (CHAR) State School District Code
  • school-precinct: (CHAR) School Precinct
  • school-year-id: (INTG) School year ID associated with this record
  • state: (CHAR) State for this carrier route
  • street-high: (CHAR) High range of street address #'s
  • street-low: (CHAR) Low Range of the street numbers
  • street-name: (CHAR) Name of the street
  • street-side: (CHAR) O = Odd side, E = Even side, B = Both
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by
  • zip-code: (CHAR) Zip code for this carrier route

    Alphabetical Index Summary

  • carrier-route-id-year: (UNIQUE, PRIMARY) school-year-id, carrier-route-id
  • carrier-route-year: school-year-id, carrier-route
  • carrier-street-year: school-year-id, street-name, street-low, street-high
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-car.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-car.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-car.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-car.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-car.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-car.p (SOURCE NOT AVAILABLE)

    Other tables who reference carrier-route

  • stu-base - Student Base record
  • stu-contact - Student Contacts file

    Tables carrier-route references

  • school-year - School year file

    Detailed Alphabetical Field Listing
    carrier-route Data type: CHARACTER
    Format: x(4)
    Help: Carrier route #/code (assigned by USPS)
    Attributes: Index Component

    carrier-route-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Internally assigned ID value for carrier route [DEFINE KEY]
    Attributes: Index Component

    city Data type: CHARACTER
    Format: x(25)
    Help: City for this carrier route

    county-code Data type: CHARACTER
    Format: x(2)
    Help: State County Code (optional)

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time record was created

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who created the record

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    external-code-1 Data type: CHARACTER
    Format: x(20)
    Help: Code to map to an external system

    external-code-2 Data type: CHARACTER
    Format: x(20)
    Help: Code to map to an external system

    external-code-3 Data type: CHARACTER
    Format: x(20)
    Help: Code to map to an external system

    external-code-4 Data type: CHARACTER
    Format: x(20)
    Help: Code to map to an external system

    external-code-5 Data type: CHARACTER
    Format: x(20)
    Help: Code to map to an external system

    locality-code Data type: CHARACTER
    Format: x(4)
    Help: Code for this locality/township/city/village

    locality-precinct Data type: CHARACTER
    Format: x(3)
    Help: Precinct for this locality/township/city/village

    school-district-code Data type: CHARACTER
    Format: x(3)
    Help: State School District Code

    school-precinct Data type: CHARACTER
    Format: x(3)
    Help: School Precinct

    school-year-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: School year ID associated with this record
    Attributes: Index Component

    state Data type: CHARACTER
    Format: !!
    Help: State for this carrier route

    street-high Data type: CHARACTER
    Format: x(8)
    Help: High range of street address #'s
    Attributes: Index Component

    street-low Data type: CHARACTER
    Format: x(8)
    Help: Low Range of the street numbers
    Attributes: Index Component

    street-name Data type: CHARACTER
    Format: x(22)
    Help: Name of the street
    Attributes: Index Component

    street-side Data type: CHARACTER
    Format: !
    Help: O = Odd side, E = Even side, B = Both

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Record last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

    zip-code Data type: CHARACTER
    Format: xxxxx-xxxx
    Help: Zip code for this carrier route

    Created on 05/07/2012 by DBHTML V1.2