SCD_IDDESCR_TMPLATSCD_PRO_TMPL_VW(SQL View) |
Index Back |
|---|---|
Template Search Result |
| SELECT SCD_TEMPLATE_NAME %Concat CHR(127) %Concat '/' %Concat SCD_TEMPLATE_ID %Concat CHR(127) %Concat '/' %Concat %NumToChar(SCD_VERSION_NBR) , SCD_TEMPLATE_ID , SCD_VERSION_NBR , SCD_TEMPLATE_NAME , SCD_AVAIL_DATE , SCD_OWNER_ID , O.OPRDEFNDESC , SCD_DESCR_LONG FROM %Table(SCD_TEMPLATE_HD) H JOIN PSOPRDEFN O ON (H.SCD_OWNER_ID = O.OPRID) WHERE H.SCD_TEMPLATESTATUS = 'AV' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 2 | SCD_VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Version Number |
| 3 | SCD_TEMPLATE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 4 | SCD_IDDESCR_TMPLAT |
Character(50) | VARCHAR2(50) NOT NULL | Template Name |
| 5 | SCD_AVAIL_DATE | Date(10) | DATE | Available or As of Date |
| 6 | SCD_OWNER_ID | Character(30) | VARCHAR2(30) NOT NULL | Owner ID |
| 7 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 8 | SCD_DESCR_LONG | Long Character | CLOB | Long Description |