UPG_SPRO_AET

(SQL Table)
Index Back

sPro Upgrade State Record

sPro Upgrade State Record - This is the default record used to store temporary values used during the upgrade process. For Attachments, use UPG_SPRO2_AET and for Installation Parameters or Static parameters, use UPG_SPRO3_AET state records instead.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
9 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
10 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
11 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
12 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
13 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
14 ADDRESS3_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 3
15 ADDRESS4_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 4
16 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
17 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
18 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
19 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
20 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
21 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
22 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
23 REQ_DT Date(10) DATE Requisition Date
24 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
25 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
26 WO_STATUS Character(1) VARCHAR2(1) NOT NULL Work Order Status
A=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
27 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
28 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
29 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
30 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
31 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
32 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
33 TE_APPROVER Character(30) VARCHAR2(30) NOT NULL Time Approver
34 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
35 END_DATE Date(10) DATE End Date
36 START_DATE Date(10) DATE Start Date for Gen Standing PO
37 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
38 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
39 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
40 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
41 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
42 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
43 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
44 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days
45 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
46 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
47 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
48 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
49 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
51 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
52 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
53 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
54 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
55 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
56 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
57 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
58 TRANS_DT Date(10) DATE Transaction Date
59 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
60 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
61 INV_LINE_STATUS Character(4) VARCHAR2(4) NOT NULL Invoice Line Status
1=Generated
10=Adjusted by Ent Approver
11=Adjusted by Enterprise
2=Approved by Enterprise
3=Submitted to Enterprise
4=Denied by Enterprise
5=Submitted to Supplier
6=Approved by Supplier
7=Denied by Supplier
8=Canceled
9=Adjusted by Supplier
62 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
63 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
64 SPF_YRS_EXPERIENCE Character(4) VARCHAR2(4) NOT NULL Years Experience
65 SP_DURATION Character(4) VARCHAR2(4) NOT NULL Duration field
-1=No Perference
1=Less than 1 month
2=1-3 months
3=3-6 months
4=6-12 months
5=More than 12 months
66 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
67 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
68 COMPUNIT Character(3) VARCHAR2(3) NOT NULL Unit of Measure
69 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
70 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
71 WO_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL work order rate in the base currency
72 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate
73 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
74 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
75 SPF_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Base Rate field for sPro Requisitions
76 SP_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL pay rate
77 SP_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL fixed costs
78 SP_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL vendor markup
79 SP_3RDPARTY_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL third party markup amount
80 SPF_EXPENSE_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate
81 SPF_EXPENSE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount.
82 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
83 SPF_REQ_LN_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the supplier's total rate.
84 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
85 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
86 SP_CUR_BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Used to store the current billed amount with respect to Reassign WorkOrders.
87 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
88 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
89 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
90 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
91 UPG_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL This field is used during the upgrade process to convert old Activity IDs to new Activity IDs. The old Activity ID comes from PROJ_ACTIVITY and is being renamed to a unique ACTIVITY_ID so that it can be inserted into FS_ACTIVITY_TBL to avoid any data collisions.
92 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
93 SP_TASKID Number(15,0) DECIMAL(15) NOT NULL Logistical Task ID
94 SP_GROUPID Number(15,0) DECIMAL(15) NOT NULL Groupid field
95 SP_ATTR Character(4) VARCHAR2(4) NOT NULL Services Procurement Attribute
AD01=Adhoc 1
AD02=Adhoc 2
AD03=Adhoc 3
AD04=Adhoc 4
AD05=Adhoc 5
AMNT=Amount
CMPT=Competency
CNDT=Candidate
EXPR=Experience
INTR=Inteview
NDDT=End Dt
RATE=Rate
RSTM=Res Time
STDT=Start Dt
TCMT=Tele Comut
TRVL=Travel
XPNS=Expenses
96 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
97 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
98 DESCR Character(30) VARCHAR2(30) NOT NULL Description
99 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
100 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
101 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
102 MIN_DT Date(10) DATE Minimum Date
103 MAX_DT Date(10) DATE Max Date
104 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
105 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
106 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
107 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
108 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
109 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
110 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
PSF=User Def
UNS=UN/SPSC
111 SP_SHOW_BID Character(1) VARCHAR2(1) NOT NULL Show Bid
N=Hide Rate
Y=Display Rate
112 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
F=Fixed Amount
M=Milestone
P=Percentage
R=Rate Based
113 SP_ADD_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Allow add activities
114 EFFDT Date(10) DATE Effective Date
115 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
116 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
117 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
118 NOTIFY_ON_DT_CONS Character(1) VARCHAR2(1) NOT NULL Notify on End Date/Consumption
119 WO_NOTIFY_BY Character(2) VARCHAR2(2) NOT NULL WorkOrder Alert Notification Method
EM=Email and Worklist
WL=Worklist Only
120 SP_COUNTER Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
121 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
122 COUNTER8 Number(8,0) INTEGER NOT NULL Counter - Unsigned 8
123 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
124 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
125 SP_APPROVAL_TYPE Character(1) VARCHAR2(1) NOT NULL Field to indicate the approval tasks
O=Off-Board
R=Pre-Approval
T=Post-Approval
X=Terminate
126 SP_TYPE_OF_EXECUTN Character(1) VARCHAR2(1) NOT NULL Type of Task Execution
A=Automatic
M=Mandatory
O=Optional
127 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
128 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
129 ADJUST_DT Date(10) DATE Transaction Date
130 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
131 HISTORY_DTTM DateTime(26) TIMESTAMP History Date/Time
132 COMMENTS_2000 Long Character CLOB Comment Text
133 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
134 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
135 SPF_ATTACH_NUM Number(5,0) INTEGER NOT NULL Attachment Number
136 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
137 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
138 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID
139 SERVER_TYPE Character(1) VARCHAR2(1) NOT NULL One of type ftp or DB, marks each registered attachment server.
D=Database server
F=FTP server
U=URL Server
140 SERVER_PATH Character(254) VARCHAR2(254) NOT NULL For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
141 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
142 COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
BF=Bid Factor
CBF=Analysis Collab Bid Factor
HDR=Header
LIN=Line
SHP=Ship To Location
143 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
144 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
145 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
146 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
147 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
148 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
149 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
150 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
151 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
152 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
153 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
154 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
155 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2