HRS_ATCH_REPS_I (SQL View)	Index Back
Job Offer Document Attachments Job Offer Document Attachments

HRS_ATCH_REPS_I

(SQL View)

Job Offer Document Attachments

SELECT '000000000000000000' AS HR_ATT_ENT_ID , HR_ATT_CNFG_ID , ' ' , ' ' , %subrec(FILE_ATTACH_SBR, A) , %DateTimeNull FROM PS_HR_ATT_CNFG_TBL A WHERE 1 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

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

7 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	HR_ATT_ENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Authorization Entry ID
2	HR_ATT_CNFG_ID	Character(18)	VARCHAR2(18) NOT NULL	Attachment Configuration
3	HR_ATT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Attachment Types 001=URL 002=Attachment 003=Document Definition 004=Note
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
6	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
7	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.