BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EMPLIDPrompt Table: PEOPLE_SRCH
REFUND_REV_VW(SQL View) |
Index Back |
|---|---|
Refund approval viewSelect refund_hdr rows of data that require a refund approval |
| SELECT DISTINCT a.business_unit , a.emplid , b.name FROM PS_REFUND_HDR a , PS_SCC_PRI_NAME_VW b WHERE a.emplid = b.emplid AND a.refund_status IN ('A','B','C','D','P','S','I') |
| # | 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_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |