HR_OBD_AG_ATT (SQL Table)	Index Back
OnBoarding AG Attachment Upld Table captures: 1) Documents uploaded from the AG Documents step. 2) Documents acknowledged from the AG Documents step. 3) Documents uploaded from the AG Attachments step. A unique SEQNO value is assigned within the AG step instance.

HR_OBD_AG_ATT

(SQL Table)

OnBoarding AG Attachment Upld

Table captures: 1) Documents uploaded from the AG Documents step. 2) Documents acknowledged from the AG Documents step. 3) Documents uploaded from the AG Attachments step. A unique SEQNO value is assigned within the AG step instance.

Related Language Record: HR_OBD_AG_ATTLG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID

2 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document Id

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

7 ATTACH_DESCR Character(50) VARCHAR2(50) NOT NULL Document

8 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN

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

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

11 ATTACH_EMP_ACTION Character(1) VARCHAR2(1) NOT NULL Employee Action Required
A=Acknowledge Document
N=None
U=Upload Document
Default Value: N

12 PTAI_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Template ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTAI_LIST_ID	Character(31)	VARCHAR2(31) NOT NULL	Action Items - Action Item List ID
2	PTAI_ITEM_ID	Character(31)	VARCHAR2(31) NOT NULL	Action Items - Action Item ID
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document Id
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	ATTACH_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Document
8	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN). Prompt Table: PSURLDEFN
9	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
10	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
11	ATTACH_EMP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Employee Action Required A=Acknowledge Document N=None U=Upload Document Default Value: N
12	PTAI_PARENT_TMPL	Character(31)	VARCHAR2(31) NOT NULL	Template ID
13	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.
14	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.