APS_CREW_VW(SQL View) |
Index Back |
|---|---|
APS Integ Crew View |
| SELECT C.WORK_CENTER_CODE , R.CREW_CODE , C.BUSINESS_UNIT , C.DESCRSHORT , C.DESCR , C.CALENDAR_CODE , C.CREWSIZE , C.AVAIL_PERCENTAGE , R.RESRC_TYPE FROM PS_EN_WORK_CENTER C , PS_EN_WC_RESRC R WHERE C.WORK_CENTER_CODE = R.WORK_CENTER_CODE AND C.BUSINESS_UNIT = R.BUSINESS_UNIT AND R.CREW_CODE <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 2 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CALENDAR_CODE | Character(10) | VARCHAR2(10) NOT NULL | This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts. |
| 7 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
| 8 | AVAIL_PERCENTAGE | Number(3,0) | SMALLINT NOT NULL | CN#PL800-33.0 MACN 07/13/99 - Utilization factor for aggregate resources. |
| 9 | RESRC_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Primary Crew 20=Alt Crew 30=Primary Machine 40=Alt Machine 50=Primary Tool 60=Alternate Tool |