QS_ACL_HDR8_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT ,A.SESSN_ID ,A.STREAM_ROOT_ID ,A.QS_SESSN_DESCR ,A.SESSN_STS_CD ,A.SESSN_CRE_DTTM ,C.OPERATOR ,B.inv_item_id ,B.work_center_code ,B.machine_code ,B.station_code ,B.cust_id ,B.vendor_id ,B.task_code ,B.prdn_area_code ,B.crew_code ,B.tool_code ,B.compl_op_seq ,B.production_type ,B.qc_step_id ,B.DE_SETUP_NAME FROM PS_QS_SESSN_HDR8 A ,PS_QS_STREAM_ROOT B ,PS_QS_SUBGROUP C WHERE (B.STREAM_ROOT_ID = A.STREAM_ROOT_ID AND C.BUSINESS_UNIT=A.BUSINESS_UNIT AND C.SESSN_ID=A.SESSN_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SESSN_ID | Character(30) | VARCHAR2(30) NOT NULL | Session ID |
| 3 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 4 | QS_SESSN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Session |
| 5 | SESSN_STS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Select Session for Edit
ALLO=Allocated ANLZ=Analyzed DISC=Discarded DISP=Dispatched SAVE=Saved SUBM=Submitted |
| 6 | SESSN_CRE_DTTM | DateTime(26) | TIMESTAMP | Date Created |
| 7 | OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 10 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 11 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 12 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 13 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 14 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 15 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 16 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 17 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 18 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 19 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 20 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 21 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |