SCC_CAF_RAT_VW(SQL View) |
Index Back |
|---|---|
CAF view |
| SELECT A.SCC_ENTITY_ID ,c.SCC_ENTITY_ID ,B.SCC_CAF_ATTRIB_NM ,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE( REPLACE( REPLACE (B.SCC_CAF_ATTRIB_NM , ' ' ,'_') , ';' ,'_') , '+' ,'_') , '%' ,'_') , '&' ,'_') , '''' ,'_') , '!' ,'_') , '#' ,'_') , '$' ,'_') ,D.SCC_CAF_ATTR_TYPE ,D.DESCR ,B.SCC_CAF_ATR_REQ ,B.SCC_CAF_ATR_REP ,D.SCC_LOV_UID ,D.SCC_CAF_ATTR_DEC ,D.SCC_CAF_ATTR_INT ,D.SCC_CAF_ATTR_DEF ,D.SCC_APPCLASSNAME ,A.RECNAME FROM PS_SCC_CAF_RATRHDR A , PS_SCC_CAF_RECATTR B LEFT OUTER JOIN PS_SCC_CAF_RAT_ENT C ON B.RECNAME=C.RECNAME AND B.SCC_CAF_ATTR_SEQ=C.SCC_CAF_ATTR_SEQ , PS_SCC_CAF_ATTRIBS D WHERE B.SCC_CAF_ATTRIB_NM=D.SCC_CAF_ATTRIB_NM AND A.RECNAME=B.RECNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCC_CAF_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL | CAF Entity ID |
| 2 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entitiy ID
Prompt Table: SCC_ENTITY_PT |
| 3 | SCC_CAF_ATTRIB_NM |
Character(20) | VARCHAR2(20) NOT NULL |
Common Attribute
Prompt Table: SCC_CAF_ATTRIBS |
| 4 | SCC_PROP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Property Name |
| 5 | SCC_CAF_ATTR_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Attribute Type
Prompt Table: SCC_CAF_ATTRTYP |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | SCC_CAF_ATR_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required
Y/N Table Edit Default Value: N |
| 8 | SCC_CAF_ATR_REP | Character(1) | VARCHAR2(1) NOT NULL |
Repeatable
Y/N Table Edit Default Value: N |
| 9 | SCC_LOV_UID | Character(40) | VARCHAR2(40) NOT NULL |
LOV Unique ID
Prompt Table: SCC_LOV_SRCH_VW |
| 10 | SCC_CAF_ATTR_DEC | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 11 | SCC_CAF_ATTR_INT | Number(2,0) | SMALLINT NOT NULL | Integer Positions |
| 12 | SCC_CAF_ATTR_DEF | Character(20) | VARCHAR2(20) NOT NULL | Default Value |
| 13 | SCC_APPCLASSNAME | Character(190) | VARCHAR2(190) NOT NULL |
Used to represent an application class as a single string. Usually
RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)
Prompt Table: SCC_APPCLASS_PT |
| 14 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |