IN_TM_FLD_VW_2(SQL View) |
Index Back |
|---|---|
Template Code FieldsSSR:07/28/04:View used in template maintenance page |
| SELECT A.IN_TM_CODE , A.IN_TM_CATEGORY , A.IN_TM_SUB_CATEGORY , B.LANGUAGE_CD , A.FIELDNAME , B.LONGNAME , A.IN_TM_FLD_DISPLAY , A.FIELDTYPE , A.LENGTH , A.REQUIRED_FIELD , A.VALUE_REQUIRED , A.SORT_SEQ_NBR , A.IN_TM_SHOW_TOFLG , A.IN_TM_APPEND_ROW , A.IN_TM_XLATLONGNAME FROM PS_IN_TM_DEFN_CAT C ,PS_IN_TM_DEFN_SCAT D ,PS_IN_TM_DEFN_FLD A ,PSDBFLDLABLLANG B WHERE C.IN_TM_CODE =D.IN_TM_CODE AND C.IN_TM_CATEGORY=D.IN_TM_CATEGORY AND D.IN_TM_CODE =A.IN_TM_CODE AND D.IN_TM_CATEGORY=A.IN_TM_CATEGORY AND D.IN_TM_SUB_CATEGORY=A.IN_TM_SUB_CATEGORY AND C.SYSTEM_DATA_FLG = 'N' AND D.SYSTEM_DATA_FLG = 'N' AND A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  IN_TM_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Template Code |
| 2 | IN_TM_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Template Category |
| 3 | IN_TM_SUB_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Template Subcategory |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 7 | IN_TM_FLD_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Display
0=Edit Field 1=Check Box 2=List 3=Blank 4=Xlat 5=Edit Button 6=Ctrl Xlat 7=Ctrl Checkbox 8=Control Default Value: 0 |
| 8 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 9 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 10 | REQUIRED_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
* Required Field
Y/N Table Edit Default Value: N |
| 11 | VALUE_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Value Required
N=Not Required O=Optional Y=Required Y/N Table Edit Default Value: N |
| 12 | SORT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sort Sequence Number |
| 13 | IN_TM_SHOW_TOFLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Show Range
Y/N Table Edit Default Value: N |
| 14 | IN_TM_APPEND_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Display in 2nd Column
Y/N Table Edit Default Value: N |
| 15 | IN_TM_XLATLONGNAME | Character(1) | VARCHAR2(1) NOT NULL |
Display Translate Long Name
Y/N Table Edit Default Value: N |