EG_ECO_HEADR_FS(SQL View) |
Index Back |
|---|---|
Shared ECO Header View07/11/97 - Use subrecord eg_eco_hdfs_sbr for ECO Alert Splits |
| select business_unit, eco_id, eco_state, %subrec(eg_eco_hdfs_sbr,a) from PS_EG_ECO_HEADER a where a.eco_state='CO' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 3 | ECO_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request Default Value: CO |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | EG_WF_RTG_TYPE | Character(10) | VARCHAR2(10) NOT NULL | ECO Type |
| 7 | EG_UDEF_ACTY | Character(10) | VARCHAR2(10) NOT NULL | ECO Activity |
| 8 | EG_SUBMIT_WF | Character(1) | VARCHAR2(1) NOT NULL |
Submit WF
N=No S=Submitted Y=Yes Default Value: N |
| 9 | EG_APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Converted Default Value: P |
| 10 | EG_DEN_CNL_REASON | Character(254) | VARCHAR2(254) NOT NULL | Deny/Cancel Reason |
| 11 | EG_CLASSIFICATION | Character(10) | VARCHAR2(10) NOT NULL | Classification |
| 12 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL | Priority Code |
| 13 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 14 | EG_REQUESTOR | Character(30) | VARCHAR2(30) NOT NULL | Requested by |
| 15 | EG_ANALYST | Character(30) | VARCHAR2(30) NOT NULL | Analyst |
| 16 | EG_REQ_DTTM | DateTime(26) | TIMESTAMP |
Date/Time Created
Default Value: %date |
| 17 | EG_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Converted from ECR
Y/N Table Edit Default Value: N |
| 18 | EG_UPDATE_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Update Mode
01=Automatic / Schedule 02=Manual Default Value: 02 |
| 19 | EG_RELEASE_DATE | Date(10) | DATE |
07/31/00...LAJ
Added eg_release_date2 label id. This will be used on the ECO line status page.
Default Value: %date |
| 20 | EG_ORIG_DATE | Date(10) | DATE |
Orig Sched Rel Date
Default Value: %date |
| 21 | EG_LONG_TEXT | Long Character | CLOB | Comments |