UPG_PC_AET

(SQL Table)
 Index Back

Projects Upgrade State Record

State record used for Projects Upgrades.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
5 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
6 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
7 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
8 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
9 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
12 BUSINESS_UNIT_SW Character(1) VARCHAR2(1) NOT NULL Show Business Unit
13 CF_STRING Character(254) VARCHAR2(254) NOT NULL CF String
14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
15 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
16 COUNTER2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 2
17 CRIT_SEQ Number(8,0) INTEGER NOT NULL Criteria Sequence
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
20 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
21 DEPTID_SW Character(1) VARCHAR2(1) NOT NULL Department ID From Transaction
22 EFFDT Date(10) DATE Effective Date
23 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
24 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
25 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #
26 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
27 FIELDNAME_DEPT Character(18) VARCHAR2(18) NOT NULL Fieldname Department ID
28 FIELDNAME_OPER Character(18) VARCHAR2(18) NOT NULL Fieldname Operating Unit
29 FIELDNAME_PROD Character(18) VARCHAR2(18) NOT NULL Fieldname Product
30 HIERARCHY_BU Character(1) VARCHAR2(1) NOT NULL Hierarchy Business Unit
1=First
2=Second
3=Third
4=Fourth
31 HIERARCHY_DEPTID Character(1) VARCHAR2(1) NOT NULL Hierarchy Department
1=First
2=Second
3=Third
4=Fourth
32 HIERARCHY_OPERUNIT Character(1) VARCHAR2(1) NOT NULL Hierarchy Operating Unit
1=First
2=Second
3=Third
4=Fourth
33 HIERARCHY_PROD Character(1) VARCHAR2(1) NOT NULL Hierarchy Product
1=First
2=Second
3=Third
4=Fourth
34 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration
35 INTER_ORG_LEVEL Character(4) VARCHAR2(4) NOT NULL Inter-Organization Level
DFLT=Default
LVL1=Level 1
LVL2=Level 2
LVL3=Level 3
LVL4=Level 4
LVL5=Level 5
36 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
37 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
38 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
39 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
40 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
41 LAST_RESOURCE_ID Number(20,0) DECIMAL(20) NOT NULL Last Transaction ID
42 OPERUNIT_SW Character(1) VARCHAR2(1) NOT NULL Show Operating Unit
43 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID
44 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
45 PC_JOBCODE Character(6) VARCHAR2(6) NOT NULL Project Employee Job Code
46 PC_WBS_ID Character(20) VARCHAR2(20) NOT NULL This is the Projects WBS id. It is longer than the previous WBS_ID field. This field will replace the old WBS_ID field in the next major release.
47 PERIOD Number(3,0) SMALLINT NOT NULL Period
48 PRJ_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL Project GL Bus Unit
49 PROD_SW Character(1) VARCHAR2(1) NOT NULL Show Product
50 PROJ_DIST_TYPE Character(2) VARCHAR2(2) NOT NULL Project Distribution Type
AP=Accounts Payable Liability
AR=Accounts Receivable
AS=Fixed Asset
CA=Contra Asset
CG=Cost of Goods Sold
CL=Contra Liability
EX=Expense
IF=Intercompany From
IN=Inventory
IT=Intercompany To
RE=Revenue
UE=Unearned Revenue
UR=Unbilled Receivable
WP=Work in Progress
51 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
52 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
53 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
54 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
55 PSFT_PRODUCT Character(2) VARCHAR2(2) NOT NULL PeopleSoft Product
56 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
57 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
58 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
59 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
60 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
61 SETID Character(5) VARCHAR2(5) NOT NULL SetID
62 SETID2 Character(5) VARCHAR2(5) NOT NULL 2nd SetId
63 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 64 SQLID2 Character(30) VARCHAR2(30) NOT NULL SQL OBJECT WORK FIELD
    65 SQLID3 Character(30) VARCHAR2(30) NOT NULL SQL Object work field
    66 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
    67 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    68 TO_PCT Number(6,2) DECIMAL(5,2) NOT NULL To Percentage
    69 TOTAL_CNT Number(4,0) SMALLINT NOT NULL Total Objects
    70 TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
    71 TRANS_DT Date(10) DATE Transaction Date
    72 TREE_CATEGORY Character(18) VARCHAR2(18) NOT NULL Category name for the Tree
    73 TREE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree Description
    74 TREE_EFFDT Date(10) DATE Effective date of the Tree
    75 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
    76 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    77 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    78 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
    79 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
    80 UPG_RELEASE Character(4) VARCHAR2(4) NOT NULL Upgrade Application Release
    751=7.51 Release
    752=7.52 Release
    753=7.53 Release
    801=8 SP1 Release
    803=8 SP3 Release
    840=8.40 Release
    841=8.40 SP1
    880=8.80 Release
    81 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
    82 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
    83 WHERE_CLAUSE3 Character(254) VARCHAR2(254) NOT NULL Where Clause
    84 WORK_CNT Number(10,0) DECIMAL(10) NOT NULL Count of Anything
    85 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause