HR_ADDR_CHG_FMT

(SQL Table)
Index Back

Address Type

Record being used with HTML Email Approval Workflow Address Change event

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: ADDRESS_TYP_TBL

    3 ACTION_DT_SS Date(10) DATE Termination Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 ADDRESSLONG1 Long Character CLOB Formated address display field.
    6 ADDRESSLONG2 Long Character CLOB Formated address display field.
    7 ADDRESSLONG3 Long Character CLOB Formated address display field.
    8 ADDRESSLONG4 Long Character CLOB Formated address display field.
    9 ADDRESSLONG5 Long Character CLOB Formated address display field.
    10 ADDRESSLONG6 Long Character CLOB Formated address display field.
    11 ADDRESSLONG7 Long Character CLOB Formated address display field.
    12 ADDRESSLONG_CUR1 Long Character CLOB Address Long
    13 ADDRESSLONG_CUR2 Long Character CLOB Address Long
    14 ADDRESSLONG_CUR3 Long Character CLOB Address Long
    15 ADDRESSLONG_CUR4 Long Character CLOB Address Long
    16 ADDRESSLONG_CUR5 Long Character CLOB Address Long
    17 ADDRESSLONG_CUR6 Long Character CLOB Address Long
    18 ADDRESSLONG_CUR7 Long Character CLOB Address Long