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