AP_GRP_ID_VW

(SQL View)
Index Back

AP Group ID Vw

generic view to project business unit and group id information

SELECT DTTM_ASSIGNED , BUSINESS_UNIT ,GRP_AP_ID FROM PS_GRP_AP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DTTM_ASSIGNED DateTime(26) TIMESTAMP Date/Time Assigned
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AP_NONVW

3 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID