HR_ADDR_DTL_VW

(SQL View)
 Index Back

Address Type

Record being used with HTML Email Approval Workflow Address Change event

SELECT NEW.EMPLID , NEW.ADDRESS_TYPE , NEW.ACTION_DT_SS , NEW.EFFSEQ , NEW.EFF_STATUS , EMP.NAME , %Sql(HR_HT_EMAIL_DATE,NEW.ACTION_DT_SS) , NEW.WF_STATUS , 'X' , NEW.APPROVAL_REQUIRED , FMT.ADDRESSLONG1 , FMT.ADDRESSLONG2 , FMT.ADDRESSLONG3 , FMT.ADDRESSLONG4 , FMT.ADDRESSLONG5 , FMT.ADDRESSLONG6 , FMT.ADDRESSLONG7 , FMT.ADDRESSLONG_CUR1 , FMT.ADDRESSLONG_CUR2 , FMT.ADDRESSLONG_CUR3 , FMT.ADDRESSLONG_CUR4 , FMT.ADDRESSLONG_CUR5 , FMT.ADDRESSLONG_CUR6 , FMT.ADDRESSLONG_CUR7 FROM PS_HR_ADDR_CHG_DAT NEW , PS_PERSON_NAME EMP , PS_HR_ADDR_CHG_FMT FMT WHERE NEW.EMPLID = EMP.EMPLID AND NEW.EMPLID=FMT.EMPLID AND NEW.ADDRESS_TYPE = FMT.ADDRESS_TYPE AND NEW.ACTION_DT_SS= FMT.ACTION_DT_SS AND NEW.EFFSEQ=FMT.EFFSEQ

  • 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 DESCR_DATE Character(30) VARCHAR2(30) NOT NULL DATE_DESCR
    8 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    9 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.
    10 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
    N=No Approval Required
    Y=Approval Required

    Default Value: N

    11 ADDRESSLONG1 Long Character CLOB Formated address display field.
    12 ADDRESSLONG2 Long Character CLOB Formated address display field.
    13 ADDRESSLONG3 Long Character CLOB Formated address display field.
    14 ADDRESSLONG4 Long Character CLOB Formated address display field.
    15 ADDRESSLONG5 Long Character CLOB Formated address display field.
    16 ADDRESSLONG6 Long Character CLOB Formated address display field.
    17 ADDRESSLONG7 Long Character CLOB Formated address display field.
    18 ADDRESSLONG_CUR1 Long Character CLOB Address Long
    19 ADDRESSLONG_CUR2 Long Character CLOB Address Long
    20 ADDRESSLONG_CUR3 Long Character CLOB Address Long
    21 ADDRESSLONG_CUR4 Long Character CLOB Address Long
    22 ADDRESSLONG_CUR5 Long Character CLOB Address Long
    23 ADDRESSLONG_CUR6 Long Character CLOB Address Long
    24 ADDRESSLONG_CUR7 Long Character CLOB Address Long