PC_KK_TMP

(SQL Table)
Index Back

TAO/TMP - Temporary Processing

Used to hold data during processing, typically used in conjunction with an application engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
5 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
6 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
7 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
8 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
11 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
12 TRANS_DT Date(10) DATE Transaction Date
13 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount