SCC_ST_UIDSCC_ENTITY_IDSCC_PROP_NAMECB=Check Box
DD=Drop Down List
DT=Date
EB=Edit Box
PT=Prompt
TM=Time
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
SCC_ST_ENT_PROP(SQL Table) |
Index Back |
|---|---|
Service Tester Setup Dtl Props |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ST_UID |
Character(30) | VARCHAR2(30) NOT NULL | Service Tester ID |
| 2 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 3 | SCC_PROP_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Property Name |
| 4 | SCC_ORDER_NBR | Number(3,0) | SMALLINT NOT NULL | Order Number |
| 5 | SCC_ST_PROP_UITYPE | Character(2) | VARCHAR2(2) NOT NULL |
UI Widget Type
CB=Check Box DD=Drop Down List DT=Date EB=Edit Box PT=Prompt TM=Time |
| 6 | SCC_ST_DISPLAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display on Page
Y/N Table Edit Default Value: Y |
| 7 | SCC_ST_REQUIREDFLD | Character(1) | VARCHAR2(1) NOT NULL |
Required Field
Y/N Table Edit Default Value: N |
| 8 | SCC_PROP_DEFAULT | Character(254) | VARCHAR2(254) NOT NULL | Property Default |
| 9 | SCC_ST_OVRDPROPLBL | Character(50) | VARCHAR2(50) NOT NULL | Override Label |
| 10 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 11 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 12 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 13 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |