BN_LE_ATTACH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LIFE_EVENT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Life Event (e.g. Birth, Adoption, Marriage) A=Adoption B=Birth D=Divorce M=Marriage Prompt Table: W3EB_ATT_SRH_VW
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: W3EB_EMPL_VW
3	ACTION_DT_SS	Date(10)	DATE	Termination Date
4	W3EB_APPR_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Approval status for a Life Event document AP=Approved CP=Complete DL=Deleted DN=Denied NA=Needs Approval PB=Push Back SB=Submitted
5	LE_TEMPLATE_ID	Character(31)	VARCHAR2(31) NOT NULL	auto generated Template ID generated by Tools for the List
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	HR_ATT_CNFG_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Configuration
8	HR_ATT_ENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Authorization Entry ID
9	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
10	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.
11	EMPLID_CREATOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the person who originally created a note.
12	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
13	HR_ATT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Attachment Types 001=URL 002=Attachment 003=Document Definition 004=Note
14	HR_ATT_SUBJECT	Character(50)	VARCHAR2(50) NOT NULL	HR Notepad: Subject of note.
15	HR_ATT_NOTETEXT	Long Character(8095)	CLOB	HR Attachments: Text of note.
16	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
17	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
18	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File