PA_SP_EMPATTACH (SQL Table)	Index Back
Employee Verification Files

PA_SP_EMPATTACH

(SQL Table)

Employee Verification Files

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

2 VERIF_ID Number(3,0) SMALLINT NOT NULL Verification ID

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration

5 HR_ATT_ENT_ID Character(18) VARCHAR2(18) NOT NULL Attachment Authorization Entry ID

6 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

7 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.

8 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.

9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

10 HR_ATT_TYPE Character(3) VARCHAR2(3) NOT NULL Attachment Types
001=URL
002=Attachment
003=Document Definition
004=Note

11 HR_ATT_SUBJECT Character(50) VARCHAR2(50) NOT NULL HR Notepad: Subject of note.

12 HR_ATT_NOTETEXT Long Character(8095) CLOB HR Attachments: Text of note.

13 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

14 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

15 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

16 DESCR Character(30) VARCHAR2(30) NOT NULL Description

17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

18 LASTUPDDTTM 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	VERIF_ID	Number(3,0)	SMALLINT NOT NULL	Verification ID
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	HR_ATT_CNFG_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Configuration
5	HR_ATT_ENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Authorization Entry ID
6	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
7	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.
8	EMPLID_CREATOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the person who originally created a note.
9	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
10	HR_ATT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Attachment Types 001=URL 002=Attachment 003=Document Definition 004=Note
11	HR_ATT_SUBJECT	Character(50)	VARCHAR2(50) NOT NULL	HR Notepad: Subject of note.
12	HR_ATT_NOTETEXT	Long Character(8095)	CLOB	HR Attachments: Text of note.
13	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
14	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
15	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
17	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18	LASTUPDDTTM	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.