BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
AM_WC_PREAM3_VW(SQL View) |
Index Back |
|---|---|
AM_WC_PREAM_VWView for WorkCenter. Record Intfc_Pre_Am pending rows. |
| SELECT BUSINESS_UNIT_AM , COUNT(*) FROM PS_INTFC_PRE_AM WHERE LOAD_STATUS = 'NEW' GROUP BY BUSINESS_UNIT_AM |
| # | 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_AM_NONVW |
| 2 | TOTAL_ROWS_CNT | Number(13,0) | DECIMAL(13) NOT NULL | Total Rows Pending |