HRRC_RECEIVD_VW(SQL View) |
Index Back |
|---|---|
Employee Recognition Jobs |
| SELECT A.RC_RECOG_ID , A.RC_EMPLID_SENT , A.RC_SENT_DTTM , A.SEQNUM , A.RC_RECOG_TEXT , A.HRRC_CATEGORY_TP , A.HRRC_IMPACT_TYPE , A.RC_VISIBILITY , A.RC_CMTS_ALLOWED , A.RC_RECOG_HIDDEN , A.RC_PROJECT_NAME , B.RC_EMPLID_RECEIVED , B.EMPL_RCD , B.RC_EE_VIEWED_YN , B.RC_ADD_TO_DOC_SW , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_PERSON_NAME P WHERE A.RC_RECOG_HIDDEN = 'N' AND B.RC_RECOG_ID = A.RC_RECOG_ID AND B.RC_EMPLID_RECEIVED = P.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_RECOG_ID | Number(8,0) | INTEGER NOT NULL | Recognition ID |
| 2 | RC_EMPLID_SENT | Character(11) | VARCHAR2(11) NOT NULL | Recognition Sender |
| 3 | RC_SENT_DTTM | DateTime(26) | TIMESTAMP | Sent Timestamp |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | RC_RECOG_TEXT | Long Character(350) | VARCHAR2(350) | Text of the recognition set at 350 characters |
| 6 | HRRC_CATEGORY_TP | Character(8) | VARCHAR2(8) NOT NULL |
Category Type
Prompt Table: HRRC_CATEGRY_TP |
| 7 | HRRC_IMPACT_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Impact Type
Prompt Table: HRRC_IMPACT_TYP |
| 8 | RC_VISIBILITY | Character(1) | VARCHAR2(1) NOT NULL |
Visibility
A=Everyone E=Employee M=Employee and Manager |
| 9 | RC_CMTS_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
Comments Allowed
N=No Y=Yes Y/N Table Edit |
| 10 | RC_RECOG_HIDDEN | Character(1) | VARCHAR2(1) NOT NULL |
Recognition Hidden
Y/N Table Edit |
| 11 | RC_PROJECT_NAME | Character(60) | VARCHAR2(60) NOT NULL | Project |
| 12 | RC_EMPLID_RECEIVED | Character(11) | VARCHAR2(11) NOT NULL | Recognition Recipient |
| 13 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 14 | RC_EE_VIEWED_YN | Character(1) | VARCHAR2(1) NOT NULL |
Employee Viewed
Y/N Table Edit |
| 15 | RC_ADD_TO_DOC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Add post to document
Y/N Table Edit |
| 16 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 17 | NAME_DISPLAY_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Uppercase version of Name to improve performance on searches. |