RUN_CNTL_FACTSI

(SQL Table)
Index Back

FACTS I Run Request Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Default Value: OPR_DEF_TBL_FS.LEDGER

Prompt Table: SP_BULEDD_NONVW

6 GL_FACTSI_DEPT Character(2) VARCHAR2(2) NOT NULL FACTS I Department Code - needed for FACTS I flat-file submission
7 FISCAL_YEAR_FROM Number(4,0) SMALLINT NOT NULL Fiscal Year
8 FISCAL_YEAR_TO Number(4,0) SMALLINT NOT NULL Range To Fiscal Year
9 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period
10 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
11 BALANCE_FWD_SW Character(1) VARCHAR2(1) NOT NULL A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward
O=Other
Y=Carry Forward

Y/N Table Edit

Default Value: N

12 INCLUDE_ADJ_PER Character(1) VARCHAR2(1) NOT NULL Include Adjustment Period(s)

Y/N Table Edit

Default Value: N

13 DISPLAY_26_DIGITS Character(1) VARCHAR2(1) NOT NULL Display Full Numeric Field
N=No
Y=Yes

Default Value: N

14 TREE_GRP Character(10) VARCHAR2(10) NOT NULL FACTS Tree Group

Prompt Table: FACTS_TREE_GRP
Set Control Field: BUSINESS_UNIT

15 TSYMBOL_ATTRIB Character(16) VARCHAR2(16) NOT NULL Treasury Symbol Attribute
16 TRIAL_BAL_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies the type of trial balance report requested. This will drive how the data is accumulated/summarized.
0=Pre-Closing
1=Pre-Closing, Adjustments Only
2=Closing

Default Value: 0