RY_CHOICE_IDA=Active
D=Design
I=Inactive
P=Pause
RY_PROF_ELEM_CH(SQL Table) |
Index Back |
|---|---|
Profile Element ChoiceStore all Possible Choice for a Profile Element |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_CHOICE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | ID for Choice ELement - Dialog Document |
| 2 | RY_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 3 | RY_PRNT_CHOICE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Parent Choice system ID used by Dynamic Enumeration feature to establish parent child relationship. |
| 4 | RY_ATTR_CHOICE_ID | Character(50) | VARCHAR2(50) NOT NULL | Element Attribute Choice ID for Rating |
| 5 | RY_CHOICE_LABEL | Character(254) | VARCHAR2(254) NOT NULL | Choice Label for doc element Choice |
| 6 | RY_DATA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Active D=Design I=Inactive P=Pause |
| 7 | RY_CHOICE_INDEX | Number(6,0) | INTEGER NOT NULL | Choice Element Index Field - Dialog Document |
| 8 | RY_CHOICE_SYNCID | Number(12,0) | DECIMAL(12) NOT NULL | Field used by Online Marketing. |