UPG_SPRO_AET(SQL Table) |
Index Back |
---|---|
sPro Upgrade State RecordsPro 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 |