ADDR_ORDER_TBL

(SQL Table)
Index Back

Address Order Table

ADDR_ORDER_TBL indicates the order in which the selection of an individual's address is to occur.

  • Parent record: ADDR_USAGE_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    2 ADDR_USAGE_ORDER Number(4,0) SMALLINT NOT NULL Address Usage Order
    3 ADDR_USAGE_TYPE Character(2) VARCHAR2(2) NOT NULL Address Usage Type
    AD=Address
    EM=E-Mail

    Default Value: AD

    4 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: HCR_ADDR_TYP_I

    5 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other