BEN_ATT_DTL_VW

(SQL View)
 Index Back

Ben Attach Details

Attachment Details

SELECT A.EMPLID , A.BEN_EVENT_TYPE , A.BEN_EVENT_SEQ , A.SEQ_NBR , A.HR_ATT_CNFG_ID , A.HR_ATT_ENT_ID , A.CREATED_DTTM , A.LAST_UPDATE_DTTM , A.EMPLID_CREATOR , A.STATUS , A.HR_ATT_TYPE , A.HR_ATT_SUBJECT , A.HR_ATT_NOTETEXT , A.URL , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE , E.DESCR , ' ' FROM PS_BEN_ATTACH_DTL A , PS_HR_ATT_ENT_TBL E WHERE A.HR_ATT_TYPE='002' AND A.APPROVAL_REQUIRED='Y' AND A.HR_ATT_ENT_ID=E.HR_ATT_ENT_ID AND E.EFFDT= ( SELECT MAX(X.EFFDT) FROM PS_HR_ATT_ENT_TBL X WHERE X.HR_ATT_ENT_ID=E.HR_ATT_ENT_ID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record: BEN_ATT_DTL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: W3EB_EMPL_VW

    2 BEN_EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Benefits event types for attachments
    D=Dependent
    L=Life Event
    O=Open Enrollment
    3 BEN_EVENT_SEQ Number(3,0) SMALLINT NOT NULL Benefits attachment sequence
    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration
    6 HR_ATT_ENT_ID Character(18) VARCHAR2(18) NOT NULL Attachment Authorization Entry ID
    7 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    9 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.
    10 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    11 HR_ATT_TYPE Character(3) VARCHAR2(3) NOT NULL Attachment Types
    001=URL
    002=Attachment
    003=Document Definition
    004=Note
    12 HR_ATT_SUBJECT Character(50) VARCHAR2(50) NOT NULL HR Notepad: Subject of note.
    13 HR_ATT_NOTETEXT Long Character(8095) CLOB HR Attachments: Text of note.
    14 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    15 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    16 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    17 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    18 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2