HRRC_RPT_PND_VW(SQL View) |
Index Back |
|---|---|
Pending Reports |
| SELECT RC_RECOG_ID , RC_EMPLID_CMNT , RC_CMNT_SEQNUM , RC_EMPLID_REPORTED , RC_RPT_SEQNUM , RC_REPORT_TYPE , RC_REPORT_DATE , RC_REPORT_REASON , DESCRLONG , RC_REPORT_NOTE , RC_REVIEW_DECISION , RC_REVIEW_NOTE , RC_REVIEW_DATE , RC_EMPLID_REVIEWER FROM PS_HRRC_RECOG_RPT WHERE RC_REVIEW_DECISION = 'PEND' |
| # | 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_CMNT |
Character(11) | VARCHAR2(11) NOT NULL | Employee Comment |
| 3 | RC_CMNT_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Comment Sequence |
| 4 | RC_EMPLID_REPORTED |
Character(11) | VARCHAR2(11) NOT NULL | Employee Reported |
| 5 | RC_RPT_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Report Sequence Number |
| 6 | RC_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Type
C=Comment P=Original Post Default Value: P |
| 7 | RC_REPORT_DATE | Date(10) | DATE | Date Reported |
| 8 | RC_REPORT_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Report Reason
ADUL=Adult Content FALS=False Information HARA=Harassment HATE=Hate Speech NOLK=Something Else VIOL=Violence |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |
| 10 | RC_REPORT_NOTE | Long Character(350) | VARCHAR2(350) | Recognition report comment |
| 11 | RC_REVIEW_DECISION | Character(4) | VARCHAR2(4) NOT NULL |
Admins decision on showing or hiding a post
HIDE=Keep Hidden PEND=Pending SHOW=Show Default Value: PEND |
| 12 | RC_REVIEW_NOTE | Long Character(350) | VARCHAR2(350) NOT NULL | Review Note |
| 13 | RC_REVIEW_DATE | Date(10) | DATE | Review Date |
| 14 | RC_EMPLID_REVIEWER | Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |