BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PC_TEMPLATE_IDN=No
Y=Yes
PC_RESOURCES_VW(SQL View) |
Index Back |
|---|---|
3PI: Get Resources View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PC_TEMPLATE_ID , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.EMPLID , A.SCH_LABOR_IND , A.PC_MSP_RES_ID , A.DESCR254_MIXED FROM PS_PC_RATE_DTL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PC_TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 3 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 4 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 5 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | SCH_LABOR_IND | Character(3) | VARCHAR2(3) NOT NULL |
Labor Indicator
N=No Y=Yes |
| 8 | PC_MSP_RES_ID | Character(40) | VARCHAR2(40) NOT NULL | MSP Transaction Definition |
| 9 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |