HRRC_RECOG_RPT(SQL Table) |
Index Back |
---|
# | 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 |