CRAFT_SETIDCRAFT_IDWM_WO_TTCRFT_VW(SQL View) |
Index Back |
|---|---|
WO Task Tmplt Labor Craft ViewWM version of RS view RS_CRAFT_VW; equates SETID key to CRAFT_SETID key on Task Template Labor Requirements softab page display |
| SELECT SETID AS CRAFT_SETID , CRAFT_ID , CRAFT_DESCRIPTION FROM PS_RS_CRAFT_DETAIL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRAFT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Foreign key SetID to RS_CRAFT_DETAIL table |
| 2 | CRAFT_ID |
Character(16) | VARCHAR2(16) NOT NULL | Craft Identification |
| 3 | CRAFT_DESCRIPTION | Character(64) | VARCHAR2(64) NOT NULL | Release 8.9.Created by Pradeep For Craft Description |