RB_TARGT_FLD_VW(SQL View) |
Index Back |
---|---|
Targets for Import templateTargets for Import template |
SELECT A.LI_TARGET_ID , A.EFFDT , A.LI_TREE_SEQ , B.FIELDNAME , A.LI_UNIQUE_ID , A.LI_TEMPLATE_ID , A.TREE_LEVEL_NUM , A.DESCRSHORT , A.DESCR , B.LI_TEMPLATE_RULE , C.RA_PROFILE_ID , C.LI_TEMPLATE_TYPE FROM PS_RB_TARGT_STRUCT A , PS_RB_TEMPL_INTFC B , PS_RB_TEMPLATE C WHERE A.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND B.LI_TEMPLATE_ID = C.LI_TEMPLATE_ID AND B.LI_TEMPLATE_RULE IN ('04','05') AND C.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TEMPLATE Z WHERE Z.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND Z.EFFDT <= B.EFFDT) AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TEMPL_INTFC Z WHERE Z.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND Z.FIELDNAME = B.FIELDNAME AND Z.EFFDT <= A.EFFDT) AND A.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TARGT_STRUCT Z WHERE Z.LI_TARGET_ID = A.LI_TARGET_ID AND Z.LI_TREE_SEQ = A.LI_TREE_SEQ AND Z.EFFDT <= %CurrentDateIn) |
# | 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 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
5 | LI_UNIQUE_ID | Character(31) | VARCHAR2(31) NOT NULL | Unique_Id |
6 | LI_TEMPLATE_ID | Character(31) | VARCHAR2(31) NOT NULL | template identifier |
7 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
10 | 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 |
11 | RA_PROFILE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
12 | 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 |