LM_TMPL_COMP_PT(SQL View) |
Index Back |
---|
SELECT %TrimSubstr(A.PNLGRPNAME,1,18) %Concat '.' %Concat A.MARKET , A.DESCR FROM PSPNLGRPDEFN A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_TMPL_COMP_ID | Character(22) | VARCHAR2(22) NOT NULL | Component |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |