RC_LINK_VW(SQL View) |
Index Back |
---|---|
View for Action tablePrompt view for Action link. Used in Quick Code setup |
SELECT LINK_CATEGORY , LINK_VERSION , RC_LINK , LINK_DEFN_NAME , LONG_DESC , SOLVABLE_FLG FROM PS_RC_LINK_TBL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LINK_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | This identifies the category that the link will be displayed under |
2 | LINK_VERSION | Character(4) | VARCHAR2(4) NOT NULL |
Version of Human Resource Management System application.
12.1=EBS 12.1 8.0=8.0 SP1 8.3=8.3 8.8=8.8 8.9=8.9 9.0=9.0 9.1=9.1 9.2=9.2 OTH=Other |
3 | RC_LINK | Character(5) | VARCHAR2(5) NOT NULL | Case Source How this case origianated |
4 | LINK_DEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Short Description. Used on may CallCenter set-up tables |
5 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |
6 | SOLVABLE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Solvable Flag indicates if the associated Action can resolve a case.
Y/N Table Edit Default Value: N |