BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: %EDITTABLE3
VENDOR_IDPrompt Table: SPA_PL_VID_VW
PERSON_IDPrompt Table: SPA_PL_SPC_VW
WORK_ORDER_IDPrompt Table:
%EDITTABLE
Set Control Field: VENDOR_ID
PLOG_IDSPA_PLOG_ADD_VW(SQL View) |
Index Back |
|---|---|
Progress Log Add ViewProgress Log Add View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.VENDOR_ID , A.PERSON_ID , C.WORK_ORDER_ID , A.PLOG_ID , A.TEMPLATE_ID FROM PS_SPA_PLOG_HDR A , PS_SPB_SERVICE_PRV B , PS_SPA_PLOG_DTL C WHERE A.PERSON_ID = B.PERSON_ID AND (B.SP_FUNCTION_TYPE = 'PRCT' OR B.SP_FUNCTION_TYPE = 'INDP') AND A.PLOG_ID = C.PLOG_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: %EDITTABLE3 |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPA_PL_VID_VW |
| 3 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: SPA_PL_SPC_VW |
| 4 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table:
%EDITTABLE
|
| 5 | PLOG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 6 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Project Template |