SSR_FC_SETUP_KEYSSR_FC_DEST_KEYA=Attendance Roster
P=Class Permission
Default Value: A
INSTR_ROLEPI=Primary Instructor
SI=Secondary Instructor
TA=Teaching Assistant
D=Display Only
U=Update Access
SSR_FC_ATTACCVW(SQL View) |
Index Back |
|---|---|
Faculty Center Setup FluidFaculty Center Setup Fluid |
| SELECT SSR_FC_SETUP_KEY , SSR_FC_DEST_KEY , INSTR_ROLE , SSR_FC_ROLE_ACC , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_FC_ROLE_ACC WHERE SSR_FC_DEST_KEY = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_FC_SETUP_KEY |
Character(2) | VARCHAR2(2) NOT NULL | Faculty Center Setup Key |
| 2 | SSR_FC_DEST_KEY |
Character(1) | VARCHAR2(1) NOT NULL |
Faculty Center Destination Key
A=Attendance Roster P=Class Permission Default Value: A |
| 3 | INSTR_ROLE |
Character(4) | VARCHAR2(4) NOT NULL |
Instructor Role
PI=Primary Instructor SI=Secondary Instructor TA=Teaching Assistant |
| 4 | SSR_FC_ROLE_ACC | Character(1) | VARCHAR2(1) NOT NULL |
Permission Role Access
D=Display Only U=Update Access |
| 5 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 6 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 7 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 8 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |