BEN_ATT_DTL_LVW

(SQL View)
 Index Back

Ben Attach Details

Attachment Details

SELECT A.EMPLID , A.BEN_EVENT_TYPE , A.BEN_EVENT_SEQ , E.LANGUAGE_CD , 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_LNG 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_LNG X WHERE X.HR_ATT_ENT_ID=E.HR_ATT_ENT_ID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record for BEN_ATT_DTL_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    6 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration
    7 HR_ATT_ENT_ID Character(18) VARCHAR2(18) NOT NULL Attachment Authorization Entry ID
    8 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    9 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.
    10 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.
    11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    12 HR_ATT_TYPE Character(3) VARCHAR2(3) NOT NULL Attachment Types
    001=URL
    002=Attachment
    003=Document Definition
    004=Note
    13 HR_ATT_SUBJECT Character(50) VARCHAR2(50) NOT NULL HR Notepad: Subject of note.
    14 HR_ATT_NOTETEXT Long Character(8095) CLOB HR Attachments: Text of note.
    15 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    16 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    17 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    18 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    19 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2