EX_TA_ATCH_H_VW (SQL View)	Index Back
Travel Auth Header Attachment Travel Auth Header Attachment for Fluid Approvals

EX_TA_ATCH_H_VW

(SQL View)

Travel Auth Header Attachment

Travel Auth Header Attachment for Fluid Approvals

SELECT A.TRAVEL_AUTH_ID , A.SCM_ATTACH_ID , A.ATT_VERSION , P.ATTACHUSERFILE , P.ATTACHSYSFILENAME , TRAVEL_AUTH_NAME , P.ATTACH_DESCR , H.OPRID_LAST_UPDT , OP.OPRDEFNDESC , H.LASTUPDDTTM FROM PS_EX_TAUTH_HDR H , PS_EX_TA_ATT_HDR A FULL OUTER JOIN PS_PV_ATTACHMENTS P ON A.SCM_ATTACH_ID = P.SCM_ATTACH_ID AND A.ATT_VERSION = P.ATT_VERSION , PSOPRDEFN OP WHERE H.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID AND OP.OPRID = H.OPRID_LAST_UPDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.

2 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

3 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

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

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

6 TRAVEL_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.

7 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.

8 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

9 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

10 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	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
2	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
3	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
6	TRAVEL_AUTH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.
7	ATTACH_DESCR	Character(100)	VARCHAR2(100) NOT NULL	A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
8	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
9	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by
10	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.