GL_JSS_AUD_RUNC

(SQL Table)
Index Back

Audit Run Control Report

Journal Source Security Audit Run Control

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GL_JSRC_AUDIT_OPTN Character(1) VARCHAR2(1) NOT NULL Audit Option
B=Busines Unit
P=Period End Schedule
R=Role
U=User
4 BUSINESS_UNIT_LBL Character(1) VARCHAR2(1) NOT NULL Business Unit

Y/N Table Edit

Default Value: N

5 USER_TYPE Character(1) VARCHAR2(1) NOT NULL User Type for Supplier Contract Managment
E=External
I=Internal

Y/N Table Edit

Default Value: N

6 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

Y/N Table Edit

Default Value: N

7 PERIOD_END_FLG Character(1) VARCHAR2(1) NOT NULL Period End

Y/N Table Edit

Default Value: N

8 FROM_DATE Date(10) DATE From Date
9 THRU_DATE Date(10) DATE Through Date
10 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From

Prompt Table: GL_JSRC_BU_VW

11 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

Prompt Table: GL_JSRC_BU_VW