RC_SOLN_REL_VW2

(SQL View)
 Index Back

SELECT SOLUTION_ID , SOLN_RELATE_TYPE , SOLUTION_ID_RLTD , LINK_SOURCE , %subrec(RB_AUDIT_SBR, PS_RC_SOLN_RELATED) FROM PS_RC_SOLN_RELATED

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

Default Value: 999999999999999

2 SOLN_RELATE_TYPE Character(5) VARCHAR2(5) NOT NULL Solution Relationship Type

Prompt Table: RC_SOLN_RLT_TBL

3 SOLUTION_ID_RLTD Number(15,0) DECIMAL(15) NOT NULL Solution ID

Prompt Table: RC_SOLUTION

4 LINK_SOURCE Character(4) VARCHAR2(4) NOT NULL Link Source
MAN=Manual
SYS=System

Default Value: MAN

5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
6 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
7 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
8 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
9 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.
10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time