EG_ECR_ATTM_VW (SQL View)	Index Back
ECR Attachment view Created on 04/07/00 RML 04/21/2006 PWF Change field from DOCUMENT to DOCUMENT_NAME

EG_ECR_ATTM_VW

(SQL View)

ECR Attachment view

Created on 04/07/00 RML 04/21/2006 PWF Change field from DOCUMENT to DOCUMENT_NAME

SELECT a.business_unit , a.eco_id , a.eco_state , %subrec(eg_att_sbr, a) , %subrec(file_attach_sbr, a) FROM PS_EG_ECO_ATT a WHERE a.eco_state = 'CR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUMGOP_NONVW

2 ECR_ID Character(10) VARCHAR2(10) NOT NULL ECR Number

3 ECO_STATE Character(2) VARCHAR2(2) NOT NULL ECR / ECO Flag
CO=Engineering Change Order
CR=Engineering Chg Request
Default Value: CR

4 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name

5 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
Prompt Table: FILE_DIR_BU_VW

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMGOP_NONVW
2	ECR_ID	Character(10)	VARCHAR2(10) NOT NULL	ECR Number
3	ECO_STATE	Character(2)	VARCHAR2(2) NOT NULL	ECR / ECO Flag CO=Engineering Change Order CR=Engineering Chg Request Default Value: CR
4	DOCUMENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Document Path and Name
5	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension Prompt Table: FILE_DIR_BU_VW
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File