| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 3 |
MATRIX_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
CP Matrix ID Field
|
| 4 |
MATRIX_VER_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
CP Upgrade Matrix Version Number Field
|
| 5 |
NON_OWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
|
| 6 |
ACTIVE_VER_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
Active Matrix Version
|
| 7 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 8 |
CP_AREA |
Character(1) |
VARCHAR2(1) NOT NULL |
Functional Area Field
0=Distribution
1=Production
|
| 9 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 10 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 11 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 12 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 13 |
DIST_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Distribution Group
|
| 14 |
DIST_SUBGROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Distribution Subgroup
|
| 15 |
RULE_AR |
Character(254) |
VARCHAR2(254) NOT NULL |
Rule AR
|
| 16 |
DIST_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Configuration
|
| 17 |
CP_TREE |
Character(18) |
VARCHAR2(18) NOT NULL |
Model Field
|
| 18 |
CP_NODE |
Number(5,0) |
INTEGER NOT NULL |
Node Number Field
|
| 19 |
CP_NODE_GOTO_FALSE |
Number(5,0) |
INTEGER NOT NULL |
Go to False Node Field
|
| 20 |
CP_NODE_GOTO_TRUE |
Number(5,0) |
INTEGER NOT NULL |
Go to True Node Field
|
| 21 |
CP_TREE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Model Sequence Field
|
| 22 |
RULE_NUMBER |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule
|
| 23 |
CP_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Group Code Field
|
| 24 |
CP_SUBGROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Subgroup Field
|
| 25 |
DISTRIB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Distribution
|
| 26 |
RELEASING_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Releasing Rule
|
| 27 |
RELEASING_RULE_T |
Character(1) |
VARCHAR2(1) NOT NULL |
Releasing Rule Result
|
| 28 |
RELEASE_TRUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Rule Flag: True Rules
|
| 29 |
RELEASE_FALSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Rule Flag Release False
|
| 30 |
CP |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Configuration Field
|
| 31 |
CP_COMP_ID |
Character(254) |
VARCHAR2(254) NOT NULL |
Component Item ID Field
|
| 32 |
CP_COMP_ID_F |
Character(254) |
VARCHAR2(254) NOT NULL |
Formatted Component ID Field
|
| 33 |
CP_COMP_QTY |
Character(254) |
VARCHAR2(254) NOT NULL |
Component Quantity Field
|
| 34 |
CP_COMP_QTY_F |
Character(254) |
VARCHAR2(254) NOT NULL |
Formatted Component Quantity Field
|
| 35 |
CP_VARIABLE |
Character(18) |
VARCHAR2(18) NOT NULL |
Variable Field
|
| 36 |
CP_VARIABLE_DECI |
Number(1,0) |
SMALLINT NOT NULL |
Variable Decimal Field
|
| 37 |
CP_VARIABLE_LEN |
Number(2,0) |
SMALLINT NOT NULL |
Variable Length Field
|
| 38 |
CP_EFFDT |
Date(10) |
DATE |
Effective Date Field
|
| 39 |
CP_PRINT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Print Code Field
|
| 40 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 41 |
CP_TIME_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Time/Resource Type Field
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time
|
| 42 |
YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Component Yield
|
| 43 |
CP_JUMP_NODE |
Number(5,0) |
INTEGER NOT NULL |
Jump Back to Node Field
|
| 44 |
PRDN_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
CP Production Group Field
|
| 45 |
PRDN_SUBGROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
CP Production Subgroup Field
|
| 46 |
CP_VARIABLE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Variable Description Field
|
| 47 |
CP_VALUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Value Type Field
C=Character
N=Number
|
| 48 |
RULE_SEQUENCE |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 49 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 50 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 51 |
CP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Field
|
| 52 |
CP_UPG_STRING |
Character(5) |
VARCHAR2(5) NOT NULL |
Upgrade String Field
|
| 53 |
TABLE_FIELD |
Character(20) |
VARCHAR2(20) NOT NULL |
System Field Name
|
| 54 |
PICTURE_FILE |
Character(40) |
VARCHAR2(40) NOT NULL |
Picture File Name
|
| 55 |
VAR_INTL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
International Variable Type
01=Option
02=Secondary
03=Global
04=Matrix
05=Internal
06=Multiple Option
07=Value List
08=External Program
09=Character
10=Number
11=Literal
12=Boolean
14=Constant
15=Expression
16=Message
|
| 56 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 57 |
CP_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Operand 1 Field
|
| 58 |
CP_OPERAND2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Operand 2 Field
|
| 59 |
CP_OPERATOR_CB |
Character(18) |
VARCHAR2(18) NOT NULL |
Operator CB Field
|
| 60 |
CP_INTRN_TABLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Internal Query Field
|
| 61 |
CP_KEY1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Character Key 1 Field
|
| 62 |
CP_PRODUCT_LIST |
Character(20) |
VARCHAR2(20) NOT NULL |
Product List Field
Date Initials Issue # Description
022601 LPL DI-LLIU-8 8.02 - Product List on Rule Detail Enhance
New Field
|
| 63 |
CP_SYSTABLE |
Character(20) |
VARCHAR2(20) NOT NULL |
System Table Field
|
| 64 |
CP_UPG_INT1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Upgrade Field 1
|
| 65 |
CP_UPG_INT2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Upgrade Field 2
|
| 66 |
CP_MENU_SELECTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Menu Selection for the Model Builder page
01=Model
02=Rule
03=Value List
04=Constraint
05=Expression
06=Message
07=Option
08=Matrix Header
09=Secondary
10=Global
11=Multiple Option
12=Internal
13=Constant
14=Print Code
15=Template
16=[ Menu ]
17=Review Variables
18=Review Rules
19=Review Models
20=Review Print Codes
21=Matrix Detail
22=Upload/Download Matrix
23=Test Models
|
| 67 |
RULE_DESCRIPTION |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used for storing Rule Description
|
| 68 |
OPTION_DESC |
Character(25) |
VARCHAR2(25) NOT NULL |
Description
|
| 69 |
EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
|
| 70 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|