SPF_PLOG_SRCH_V

(SQL View)
Index Back

Progress Log ID Search View

Returns the available Progress Log IDs as part of the search view for Invoices

SELECT BUSINESS_UNIT , PLOG_ID FROM PS_SPA_PLOG_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: BUS_UNIT_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)