BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
ECR_IDECO_STATECO=Engineering Change Order
CR=Engineering Chg Request
Default Value: CR
DC_OBJECT_IDN=No
Y=Yes
Y/N Table Edit
Default Value: N
EG_ECR_DCM_VW(SQL View) |
Index Back |
|---|---|
Engineering ECR Doc Maint VW07/07/97 LAJ - Deleted field DC_FLOW_ECR. This view is used to select documents associated at the header level on ECRs. It uses the table that is used to store documents for ECOs at the header level as well. |
| select a.business_unit, a.eco_id, a.eco_state, %subrec(dc_dc_sbr,a) from PS_EG_ECO_DC 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 | DC_OBJECT_ID |
Character(16) | VARCHAR2(16) NOT NULL | Document Object ID |
| 5 | DC_FIXED | Character(1) | VARCHAR2(1) NOT NULL |
fixed to specific doc version
N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | DC_OBJECT_NAME | Character(254) | VARCHAR2(254) NOT NULL | Document Name |
| 7 | DC_TITLE | Character(64) | VARCHAR2(64) NOT NULL | Title |