HRRC_RECENT_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 , B.RC_EMPLID_RECEIVED , B.RC_EE_VIEWED_YN , C.EMPL_RCD , C.JOB_EFFDT , C.JOB_EFFSEQ , C.RC_MGR_VIEWED_YN , D.COMPANY , D.BUSINESS_UNIT , D.SETID_LOCATION , D.LOCATION , D.SETID_DEPT , D.DEPTID , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_JOB D , PS_PERSON_NAME P WHERE A.RC_RECOG_HIDDEN = 'N' AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND D.EMPLID = C.RC_EMPLID_RECEIVED AND D.EMPL_RCD = C.EMPL_RCD AND D.EFFDT = C.JOB_EFFDT AND D.EFFSEQ = C.JOB_EFFSEQ AND D.HR_STATUS = 'A' AND P.EMPLID = B.RC_EMPLID_RECEIVED |
| # | 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_EMPLID_RECEIVED | Character(11) | VARCHAR2(11) NOT NULL | Recognition Recipient |
| 12 | RC_EE_VIEWED_YN | Character(1) | VARCHAR2(1) NOT NULL | Employee Viewed |
| 13 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 14 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 15 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 16 | RC_MGR_VIEWED_YN | Character(1) | VARCHAR2(1) NOT NULL | Manager Viewed |
| 17 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 18 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 19 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 20 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 21 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 22 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 23 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 24 | NAME_DISPLAY_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Uppercase version of Name to improve performance on searches. |