OPRIDBUSINESS_UNITDefault Value: AV_OPR_DEF_TBL.BUSINESS_UNIT
Prompt Table: AV_BUS_UNIT_TBL
SESSION_NOAV_SESS_M_VW(SQL View) |
Index Back |
|---|---|
Session Membership viewShows all Membership sessions for the operator logged in. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT OPRID, INSTITUTION, SESSION_NO FROM PS_AV_SESSION_TBL WHERE AV_SESS_TYPE = 'M' OR AV_SESS_TYPE = 'AM' ----------------------------------------------------------------------------------------------------------------- |
| SELECT OPRID, BUSINESS_UNIT, SESSION_NO FROM PS_AV_SESSION_TBL WHERE AV_SESS_TYPE IN ('M', 'AM') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL |
| 3 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |