HR_ADDR_APVL_VW

(SQL View)
 Index Back

Address Fluid Approval View

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 , EMP.NAME_DISPLAY , ' ' , %Sql(HR_HT_EMAIL_DATE,NEW.ACTION_DT_SS) , NEW.WF_STATUS , 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
    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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    8 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    9 DESCR_DATE Character(30) VARCHAR2(30) NOT NULL DATE_DESCR
    10 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
    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