SSF_RUNGLTR_AET

(SQL Table)
Index Back

StateRec - Generate GL Trans

Default State Record for the AE program to hold Run Control Data, Business Unit SF data and counters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
6 TRANS_DT Date(10) DATE Transaction Date
7 PGM_RUN_DATE Date(10) DATE Program Run Date
8 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
11 GL_LEVEL_COMMIT Character(1) VARCHAR2(1) NOT NULL Commit Level
E=Commit at the End
L=Commit Level
V=Commit Every Item
12 GL_POST_COMMIT Number(6,0) INTEGER NOT NULL GL Post Commit
13 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency
14 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
15 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
16 SF_LINE_NBR Number(9,0) DECIMAL(9) NOT NULL Student Financials Line Number
17 SF_NBR_ACCTG_LN Number(8,0) INTEGER NOT NULL Number of Records Generated
18 SSF_MAX_COMMIT_CNT Number(6,0) INTEGER NOT NULL Maximum Commit Count
19 SSF_COMMIT_CNT Number(6,0) INTEGER NOT NULL Commit Count
20 DB_CR_IND Character(1) VARCHAR2(1) NOT NULL Debit Credit Indicator
C=Credit
D=Debit
21 MONETARY_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Monetary Amount
22 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance
23 DERIVED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Derived Amount