RY_VC_TYPE_IDA=Active
D=In Design
I=Archived
Default Value: D
N=Sync
Y=Async
N=Not In Document
Y=In Document
Default Value: N
Default Value: N
N=No
Y=Yes
Default Value: N
N=No
Y=Yes
J=Java
P=People Code
Y/N Table Edit
Default Value: N
RY_CONST_ACT_VW(SQL View) |
Index Back |
|---|---|
VC Extension viewVC constant view for VC Picker. |
| SELECT %subrec(RY_VC_TYPE_SBR, A) FROM PS_RY_VC_TYPE A WHERE A.DEVELOPER = 'S' AND A.RY_VC_TYPE_STATUS = 'A' AND A.GROUP_ID = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_VC_TYPE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Custom Variable Contentt Type ID. |
| 2 | RY_NAME254 | Character(254) | VARCHAR2(254) NOT NULL | 254 character name field for names. |
| 3 | DEVELOPER | Character(1) | VARCHAR2(1) NOT NULL | Developer |
| 4 | RY_VC_TYPE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Active D=In Design I=Archived Default Value: D |
| 5 | RY_IS_ASYNC | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
N=Sync Y=Async |
| 6 | BEAN_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Bean Class Name |
| 7 | SERVLET_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Servlet Class Name |
| 8 | RY_VC_PARAM_SET_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 9 | RY_BEAN_JAR | Character(254) | VARCHAR2(254) NOT NULL | Field used by Online Marketing. |
| 10 | RY_SERVLET_JAR | Character(254) | VARCHAR2(254) NOT NULL | Field used by Online Marketing. |
| 11 | RY_TIMEOUT | Number(19,0) | DECIMAL(19) NOT NULL | Field used by Online Marketing. |
| 12 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 13 | RY_ALLOW_DOC_ELEM | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
N=Not In Document Y=In Document Default Value: N |
| 14 | RY_ALLOW_VC_PARAM | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
Default Value: N |
| 15 | RY_ALLOW_DC_CONT | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
N=No Y=Yes Default Value: N |
| 16 | RY_ALLOW_ACT_TASK | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
N=No Y=Yes |
| 17 | RY_IMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
J=Java P=People Code |
| 18 | RYE_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | RYE_CLASSNAME - for maintaining the application class to handle the VCObject |
| 19 | PSIMAGEVER | Number(10,0) | DECIMAL(10) NOT NULL | Image Version |
| 20 | RAD_IMG_JPG | Image / Attachment | CLOB | Advisor Success Rate Image for Recommendations |
| 21 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 22 | RY_IS_READ_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
To identify if the page is read only
Y/N Table Edit Default Value: N |
| 23 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 24 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 25 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 26 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 27 | 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. |
| 28 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |