IN_TM_OPR_FLD(SQL Table) |
Index Back |
|---|---|
Template Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  IN_TM_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Template Code |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | IN_TM_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Template Category |
| 4 | IN_TM_SUB_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Template Subcategory |
| 5 | LINE_NO |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: %EDITTABLE |
| 7 | SORT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sort Sequence Number |
| 8 | FROM_DATE | Date(10) | DATE | From Date |
| 9 | TO_DATE | Date(10) | DATE | To Date |
| 10 | FROM_CHAR | Character(30) | VARCHAR2(30) NOT NULL | From Char |
| 11 | TO_CHAR | Character(30) | VARCHAR2(30) NOT NULL | To Char |
| 12 | FROM_NUM | Number(15,0) | DECIMAL(15) NOT NULL | From Num |
| 13 | TO_NUM | Number(15,0) | DECIMAL(15) NOT NULL | To Num |
| 14 | FROM_TIME2 | Time(15) | TIMESTAMP | From Time |
| 15 | TO_TIME2 | Time(15) | TIMESTAMP | to Time |
| 16 | VALUE_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Value Required
N=Not Required O=Optional Y=Required Y/N Table Edit Default Value: N |
| 17 | IN_TM_LOCK_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Display Only
Y/N Table Edit Default Value: N |
| 18 | IN_TM_SHOW_TOFLD | Character(1) | VARCHAR2(1) NOT NULL |
Show Range
Y/N Table Edit Default Value: N |
| 19 | IN_TM_HIDE_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Hide Field
Y/N Table Edit Default Value: N |
| 20 | IN_TM_APPEND_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Display in 2nd Column
Y/N Table Edit Default Value: N |
| 21 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |