EX_RISK_TR_DT_H

(SQL Table)
Index Back

Risk Time Report History

This table is used to store Risk details for Time Reports for Archiving.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
4 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 RISK_LEVEL Character(1) VARCHAR2(1) NOT NULL Risk Level
1=Level 1
2=Level 2
3=Level 3
4=Level 4
5=Level 5
7 RISK_CRITERIA Character(80) VARCHAR2(80) NOT NULL Risk Criteria
8 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
9 RISK_DESCR30 Character(30) VARCHAR2(30) NOT NULL Risk Description
10 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
11 EMAIL_APPROVALS Character(1) VARCHAR2(1) NOT NULL Email Approvals