SSR_FC_MTGSFFVW(SQL View) |
Index Back |
|---|---|
Faculty Center Setup FluidFaculty Center Setup Fluid |
| SELECT SSR_FC_SETUP_KEY , SSR_FRMFACTYP_FL , SSR_RANGE_MAX , SSR_DESCR80 , SSR_DESCR80_2 , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_FC_MTGSC_FL WHERE SSR_FRMFACTYP_FL = 'SF' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(2) | VARCHAR2(2) NOT NULL | Faculty Center Setup Key | |
| 2 | Character(2) | VARCHAR2(2) NOT NULL |
Form Factor Type
LF=Non-small Form Factor SF=Small Form Factor |
|
| 3 | SSR_RANGE_MAX | Number(5,0) | INTEGER NOT NULL | Range Max |
| 4 | SSR_DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports. |
| 5 | SSR_DESCR80_2 | Character(80) | VARCHAR2(80) NOT NULL | This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports and communications. |
| 6 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 7 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 8 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 9 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |