GL_JSS_DATA_RUN

(SQL Table)
Index Back

Journal Source Data Report

Journal Source Security Data Report

# 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 BUSINESS_UNIT_LBL Character(1) VARCHAR2(1) NOT NULL Business Unit

Y/N Table Edit

Default Value: N

4 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

7 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From

Prompt Table: GL_JSRC_BU_VW

8 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

9 USERID1 Character(30) VARCHAR2(30) NOT NULL User ID

Prompt Table: OPRID_VW

10 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

11 BUSINESS_UNIT_2 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU

Prompt Table: GL_JSRC_BU_VW

12 BUSINESS_UNIT_3 Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: GL_JSRC_BU_VW