TEST_IDSCC_CAF_ATTRIB_NMSAD_TSTIDCAF_VW(SQL View) |
Index Back |
|---|---|
Test score attribute prompt |
| SELECT A.TEST_ID , B.SCC_CAF_ATTRIB_NM , C.DESCR FROM PS_SA_TEST_TBL A , PS_SCC_CAF_RAT_VW B , PS_SCC_CAF_ATTRIBS C WHERE B.RECNAME='SAD_TESTDT' AND (B.SCC_ENTITY_ID IS NULL OR B.SCC_ENTITY_ID IN ( SELECT DISTINCT X.SCC_ENTITY_ID FROM PS_SCC_CAF_RAT_ENT X WHERE X.RECNAME = 'SAD_TESTDT' AND A.SCC_ENTITY_ID = X.SCC_ENTITY_ID)) AND C.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM AND %EffdtCheck(SA_TEST_TBL EFF, A,%currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL | Test ID |
| 2 | SCC_CAF_ATTRIB_NM |
Character(20) | VARCHAR2(20) NOT NULL | Common Attribute |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |