RY_MD_ELEM_IDC1=Choose One
C1R=Choose One (with Rating)
CM=Choose Many
DATE=Date
DEC=Decimal
FA=File
INT=Integer
LT=Text Block
PRMT=Map Field Choice to Prompt
TEXT=Text
TIME=Time
YN=Yes/No
CS_APPL_PROF_VW(SQL View) |
Index Back |
|---|---|
OLM Profile/MetaData/DocOLM Profile, MetaData, Documents and Attributes Cross Reference View �This view is used by ADM_EIP to facilitate the search |
| SELECT A.RY_MD_ELEM_ID , A.RY_ELEM_PERM_NAME , B.RY_PROF_MD_ELEM_ID , C.RY_PROF_ELEM_ID , C.RY_ATTRIB_SYNCID , D.SYNCID , D.RA_ATTRIB_RECNAME , D.RA_ATTRIB_FLDNAME , D.RA_ATTRIB_INDEX , D.RA_ATTRIB_TYPE FROM PS_RY_MDATA_ELEM A , PS_RY_DOC_DB_DEF B , PS_RY_PROF_DB_DEF C , PS_RA_ATTRIBUTE D WHERE B.RY_MD_ELEM_ID = A.RY_MD_ELEM_ID AND C.RY_MD_ELEM_ID = B.RY_PROF_MD_ELEM_ID AND D.SYNCID = C.RY_ATTRIB_SYNCID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_MD_ELEM_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 2 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 3 | RY_PROF_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 4 | RY_PROF_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile Element ID - Dialog Document |
| 5 | RY_ATTRIB_SYNCID | Number(12,0) | DECIMAL(12) NOT NULL | Field used by Online Marketing. |
| 6 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 7 | RA_ATTRIB_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Profile - Attribute record name |
| 8 | RA_ATTRIB_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Profile - Attribute field name |
| 9 | RA_ATTRIB_INDEX | Number(3,0) | SMALLINT NOT NULL | Profile - Attribute index |
| 10 | RA_ATTRIB_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Profile - attribute type
C1=Choose One C1R=Choose One (with Rating) CM=Choose Many DATE=Date DEC=Decimal FA=File INT=Integer LT=Text Block PRMT=Map Field Choice to Prompt TEXT=Text TIME=Time YN=Yes/No |