BUSINESS_UNIT_CAPrompt Table: BI_CNRCT_BU_VW
CONTRACT_NUMPrompt Table: BI_CNRCT_NUM_VW
BI_CNRCT_NUM_VW(SQL View) |
Index Back |
|---|---|
Contract Num Search PromptMass Update - Contract Num Search Prompt |
| SELECT DISTINCT BUSINESS_UNIT_CA , CONTRACT_NUM FROM PS_BI_INTFC_ERR_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_CA |
Character(5) | VARCHAR2(5) NOT NULL |
Contracts Business Unit
Prompt Table: BI_CNRCT_BU_VW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: BI_CNRCT_NUM_VW |