BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW
GRP_AP_IDDefault Value: NEXT
Default Value: %date
Default Value: OPR_DEF_TBL_FS.OPRID
GRP_AP_SRCH_VW(SQL View) |
Index Back |
|---|
| SELECT business_unit , grp_ap_id , group_dt , assigned_to_oprid FROM PS_GRP_AP |
| # | 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_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | GRP_AP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Control Group ID
Default Value: NEXT |
| 3 | GROUP_DT | Date(10) | DATE |
Group Control Date
Default Value: %date |
| 4 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Default Value: OPR_DEF_TBL_FS.OPRID |