UPG_LD_MAP_TMP (SQL Table)	Index Back
Upgrade Ledger Mapping Record Maps E&G controlled budget ledgers to corresponding commitment control ledgers; also used for splitting ledgers. -- this is the temp table

UPG_LD_MAP_TMP

(SQL Table)

Upgrade Ledger Mapping Record

Maps E&G controlled budget ledgers to corresponding commitment control ledgers; also used for splitting ledgers. -- this is the temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

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

4 LEDGER_GROUP_2 Character(10) VARCHAR2(10) NOT NULL Ledger Group

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

6 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

9 BUDGET_TYPE Character(2) VARCHAR2(2) NOT NULL Budget Type
AL=Allotment Budget
AP=Appropriation Budget
IN=Initial Budget
IS=Installment Budget
OR=Organizational Budget
OT=Other
PR=Project/Grant Budget
RE=Revenue Estimate
SU=Supplemental Budget

10 LEDGER_TYPE_KK Character(1) VARCHAR2(1) NOT NULL Commitment Control Ledger Type
0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned

11 UPDATED_FLAG Character(1) VARCHAR2(1) NOT NULL UPDATED FLAG

12 KK_SPLIT_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Split Flag
Y/N Table Edit

13 SCENARIO_ORIG Character(10) VARCHAR2(10) NOT NULL Original Scenario

14 BALANCED_LINES Character(1) VARCHAR2(1) NOT NULL Entries Must Balance
Y/N Table Edit

15 OFFSET_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Offset Account

16 DONE Character(1) VARCHAR2(1) NOT NULL Complete task

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
4	LEDGER_GROUP_2	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
5	LEDGER_2	Character(10)	VARCHAR2(10) NOT NULL	Ledger
6	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9	BUDGET_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Budget Type AL=Allotment Budget AP=Appropriation Budget IN=Initial Budget IS=Installment Budget OR=Organizational Budget OT=Other PR=Project/Grant Budget RE=Revenue Estimate SU=Supplemental Budget
10	LEDGER_TYPE_KK	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Ledger Type 0=Budget 1=Expense or Recognized Revenue 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned
11	UPDATED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	UPDATED FLAG
12	KK_SPLIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Split Flag Y/N Table Edit
13	SCENARIO_ORIG	Character(10)	VARCHAR2(10) NOT NULL	Original Scenario
14	BALANCED_LINES	Character(1)	VARCHAR2(1) NOT NULL	Entries Must Balance Y/N Table Edit
15	OFFSET_ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Offset Account
16	DONE	Character(1)	VARCHAR2(1) NOT NULL	Complete task