AV_RUNCTL_ROLE(SQL Table) |
Index Back |
|---|---|
Role Assignment Report OptionsThis record is used for the role assignments report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | PRPS_ASGN_STF_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Assigned Resource
STF=Staff UNT=Unit VOL=Volunteer Default Value: STF |
| 5 | PRPS_ASGN_CUR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Time Frame
A=All C=Current H=Historical Default Value: C |
| 6 | PRPS_ASGN_PRPS_CD | Character(6) | VARCHAR2(6) NOT NULL |
Role
Prompt Table: %EDITTABLE |
| 7 | PRPS_ASGN_SORT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Sort By
C=Count I=ID N=Name Default Value: C |
| 8 | PRPS_ASGN_SORT_ORD | Character(1) | VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending D=Descending Default Value: D |
| 9 | AV_ROLE_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Type
D=Detail S=Summary Default Value: S |