LI_TARGET_IDEFFDTDefault Value: %date
LI_TREE_SEQPrompt Table: RB_TEMPLATE
01=Manual Template
02=Profile Template
03=Implicit Template
04=Optional Template
RB_TMPL0104_VW(SQL View) |
Index Back |
|---|---|
Manual and Profile TemplatesTarget Structure having Manual and Profile Templates |
| SELECT A.LI_TARGET_ID , A.EFFDT , A.LI_TREE_SEQ , A.TREE_LEVEL_NUM , A.LI_TEMPLATE_ID , B.LI_TEMPLATE_TYPE FROM PS_RB_TARGT_STRUCT A , PS_RB_TEMPLATE B WHERE A.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND B.LI_TEMPLATE_TYPE IN ('01','02') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LI_TARGET_ID |
Character(31) | VARCHAR2(31) NOT NULL | field target identifier |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LI_TREE_SEQ |
Number(3,0) | SMALLINT NOT NULL | in what position is this tree element? |
| 4 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 5 | LI_TEMPLATE_ID | Character(31) | VARCHAR2(31) NOT NULL |
template identifier
Prompt Table: RB_TEMPLATE |
| 6 | LI_TEMPLATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
what type of import template is this?
01=Manual Template 02=Profile Template 03=Implicit Template 04=Optional Template |