RB_TEMPL_INTFC(SQL Table) |
Index Back |
|---|---|
template export definitionlists the fields exported from a template as well as the correct usage thereof |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LI_TEMPLATE_ID |
Character(31) | VARCHAR2(31) NOT NULL | template identifier |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | LI_TEMPLATE_RULE | Character(2) | VARCHAR2(2) NOT NULL |
action to take for a field in a given template
01=Generate Standard Key 02=Generate Sequence Key 03=Reference Key 04=Required Input 05=Optional Input 06=Value 07=Value Reference 08=Lookup Value 09=Concatenation 10=Insert Null 11=Generate Id - Not Key 12=Generate Datetime Stamp 13=Fetch Text 14=Staged Default 15=Mandatory Value 16=First of Group 17=Write Contact Method 18=Cache Contact Method 19=Map Field Reference 20=Bas SysId |
| 5 | LI_GROUP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
should these fields be grouped by?
Y/N Table Edit |
| 6 | LI_MATCH_TGT_REC | Character(18) | VARCHAR2(18) NOT NULL | record against which to match |
| 7 | LI_MATCH_TGT_FLD | Character(18) | VARCHAR2(18) NOT NULL | field against which to apply matching rules |
| 8 | LI_REF_TEMPL_ID | Character(31) | VARCHAR2(31) NOT NULL | template identifier |
| 9 | REF_KEYNAME | Character(18) | VARCHAR2(18) NOT NULL | Reference Keyname |
| 10 | VALUE_DISPLAY | Character(254) | VARCHAR2(254) NOT NULL | Value |
| 11 | SQL_STMT_2540 | Long Character(2540) | CLOB | SQL Statement length 2540 |