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 | SSR_FC_SETUP_KEY | Character(2) | VARCHAR2(2) NOT NULL | Faculty Center Setup Key |
2 | SSR_FRMFACTYP_FL | 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 |