SFA_RUN_SS_SEC(SQL Table) |
Index Back |
|---|---|
SFA SS Access Run Control recSFA_RUN_SS_SEC holds run control parameters to set FA self-service access in batch mode. |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 5 | FA_SS_AWD_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Self Service Awarding Access
A=Allow Access F=Use Filter Options N=Deny Access Default Value: A |
| 6 | FA_SS_INQ_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Self-Service Inquiry Access
N=Deny Access Y=Allow Access Default Value: Y |
| 7 | SFA_SS_SEC_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Run Option
A=All IDs R=ID Range Default Value: A |
| 8 | START_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Start EmplID
Prompt Table: PEOPLE_SRCH |
| 9 | END_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
End EmplID
Prompt Table: PEOPLE_SRCH |
| 10 | SFA_EASS_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Student-level access control to external award self service.
N=Deny Y=Allow Default Value: Y |