CP_MATRIX_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	MATRIX_ID	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix ID Field
3	MATRIX_DESCR	Character(30)	VARCHAR2(30) NOT NULL	CP Matrix Description Field
4	VAR_NAME_1	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix Variable 1 Field Prompt Table: %EDITTABLE10
5	VAR_INTL_CD_1	Character(2)	VARCHAR2(2) NOT NULL	CP International Variable Code 1 Field Prompt Table: CP_VAR_MTX_VW
6	VAR_TYPE_1	Character(1)	VARCHAR2(1) NOT NULL	CP Variable Type 1 Field C=Character N=Number
7	VAR_LENGTH_1	Number(2,0)	SMALLINT NOT NULL	CP Matrix Key Length 1 Field
8	VAR_DECIMAL_1	Number(1,0)	SMALLINT NOT NULL	CP Matrix Key Variable Decimal 1 Field
9	VAR_ACCESS_1	Character(1)	VARCHAR2(1) NOT NULL	CP Matrix Key Access 1 Field <=Less than or equal to ==Equal to >=Greater than or equal to
10	VAR_DESCR_1	Character(25)	VARCHAR2(25) NOT NULL	CP Matrix Key Variable Description 1 Field
11	CP_USER_CD_1	Character(10)	VARCHAR2(10) NOT NULL	Matrix Value List 1 Field Prompt Table: CP_USERCD_HDR
12	VAR_NAME_2	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix Variable 2 Field Prompt Table: %EDITTABLE11
13	VAR_INTL_CD_2	Character(2)	VARCHAR2(2) NOT NULL	CP International Variable Code 2 Field Prompt Table: CP_VAR_MTX_VW
14	VAR_TYPE_2	Character(1)	VARCHAR2(1) NOT NULL	CP Variable Type 2 Field C=Character N=Number
15	VAR_LENGTH_2	Number(2,0)	SMALLINT NOT NULL	CP Matrix Key Length 2 Field
16	VAR_DECIMAL_2	Number(1,0)	SMALLINT NOT NULL	CP Matrix Key Variable Decimal 2 Field
17	VAR_ACCESS_2	Character(1)	VARCHAR2(1) NOT NULL	CP Matrix Key Access 2 Field <=Less than or equal to ==Equal to >=Greater than or equal to
18	VAR_DESCR_2	Character(25)	VARCHAR2(25) NOT NULL	CP Matrix Key Variable Description 2 Field
19	CP_USER_CD_2	Character(10)	VARCHAR2(10) NOT NULL	Matrix Value List 2 Field Prompt Table: CP_USERCD_HDR
20	VAR_NAME_3	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix Variable 3 Field Prompt Table: %EDITTABLE12
21	VAR_INTL_CD_3	Character(2)	VARCHAR2(2) NOT NULL	CP International Variable Code 3 Field Prompt Table: CP_VAR_MTX_VW
22	VAR_TYPE_3	Character(1)	VARCHAR2(1) NOT NULL	CP Variable Type 3 Field C=Character N=Number
23	VAR_LENGTH_3	Number(2,0)	SMALLINT NOT NULL	CP Matrix Key Length 3 Field
24	VAR_DECIMAL_3	Number(1,0)	SMALLINT NOT NULL	CP Matrix Key Variable Decimal 3 Field
25	VAR_ACCESS_3	Character(1)	VARCHAR2(1) NOT NULL	CP Matrix Key Access 3 Field <=Less than or equal to ==Equal to >=Greater than or equal to
26	VAR_DESCR_3	Character(25)	VARCHAR2(25) NOT NULL	CP Matrix Key Variable Description 3 Field
27	CP_USER_CD_3	Character(10)	VARCHAR2(10) NOT NULL	Matrix Value List 3 Field Prompt Table: CP_USERCD_HDR
28	VAR_NAME_4	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix Variable 4 Field Prompt Table: %EDITTABLE13
29	VAR_INTL_CD_4	Character(2)	VARCHAR2(2) NOT NULL	CP International Variable Code 4 Field Prompt Table: CP_VAR_MTX_VW
30	VAR_TYPE_4	Character(1)	VARCHAR2(1) NOT NULL	CP Variable Type 4 Field C=Character N=Number
31	VAR_LENGTH_4	Number(2,0)	SMALLINT NOT NULL	CP Matrix Key Length 4 Field
32	VAR_DECIMAL_4	Number(1,0)	SMALLINT NOT NULL	CP Matrix Key Variable Decimal 4 Field
33	VAR_ACCESS_4	Character(1)	VARCHAR2(1) NOT NULL	CP Matrix Key Access 4 Field <=Less than or equal to ==Equal to >=Greater than or equal to
34	VAR_DESCR_4	Character(25)	VARCHAR2(25) NOT NULL	CP Matrix Key Variable Description 4 Field
35	CP_USER_CD_4	Character(10)	VARCHAR2(10) NOT NULL	Matrix Value List 4 Field Prompt Table: CP_USERCD_HDR
36	VAR_NAME_5	Character(18)	VARCHAR2(18) NOT NULL	CP Matrix Variable 5 Field Prompt Table: %EDITTABLE14
37	VAR_INTL_CD_5	Character(2)	VARCHAR2(2) NOT NULL	CP International Variable Code 5 Field Prompt Table: CP_VAR_MTX_VW
38	VAR_TYPE_5	Character(1)	VARCHAR2(1) NOT NULL	CP Variable Type 5 Field C=Character N=Number
39	VAR_LENGTH_5	Number(2,0)	SMALLINT NOT NULL	CP Matrix Key Length 5 Field
40	VAR_DECIMAL_5	Number(1,0)	SMALLINT NOT NULL	CP Matrix Key Variable Decimal 5 Field
41	VAR_ACCESS_5	Character(1)	VARCHAR2(1) NOT NULL	CP Matrix Key Access 5 Field <=Less than or equal to ==Equal to >=Greater than or equal to
42	VAR_DESCR_5	Character(25)	VARCHAR2(25) NOT NULL	CP Matrix Key Variable Description 5 Field
43	CP_USER_CD_5	Character(10)	VARCHAR2(10) NOT NULL	Matrix Value List 5 Field Prompt Table: CP_USERCD_HDR
44	CP_VALUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Value Type Field C=Character N=Number Default Value: C
45	CP_VARIABLE_LEN	Number(2,0)	SMALLINT NOT NULL	Variable Length Field Default Value: 0
46	CP_VARIABLE_DECI	Number(1,0)	SMALLINT NOT NULL	Variable Decimal Field Default Value: 0
47	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active Default Value: Y
48	CP_IN_USE	Character(1)	VARCHAR2(1) NOT NULL	Production Matrix Only Field Y/N Table Edit Default Value: N
49	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.