SCD_TEMPLATE_IDSCD_VERSION_NBRDefault Value: 1
SCD_OWNER_IDSCD_TESTYPCN_VW(SQL View) |
Index Back |
|---|---|
Template Type CountTemplate Section Type Count |
| SELECT A.SCD_TEMPLATE_ID ,A.SCD_VERSION_NBR ,A.SCD_OWNER_ID ,CASE WHEN B.SCD_SECT_TYPE = 'S' THEN COUNT(*) ELSE 0 END ,CASE WHEN B.SCD_SECT_TYPE = 'K' THEN COUNT(*) ELSE 0 END ,CASE WHEN B.SCD_SECT_TYPE = 'C' THEN COUNT(*) ELSE 0 END FROM PS_SCD_TEMPL_HD_VW A , PS_SCD_TEMPL_SECT B WHERE A.SCD_TEMPLATE_ID = B.SCD_TEMPLATE_ID AND A.SCD_VERSION_NBR = B.SCD_VERSION_NBR GROUP BY A.SCD_TEMPLATE_ID,A.SCD_VERSION_NBR,A.SCD_OWNER_ID,B.SCD_SECT_TYPE |
| # | 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
Default Value: 1 |
| 3 | SCD_OWNER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Owner ID |
| 4 | SCD_SUBJ_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Subjective Count |
| 5 | SCD_KPI_CNT | Number(10,0) | DECIMAL(10) NOT NULL | KPI Count |
| 6 | SCD_COMB_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Combo Count |