GPMX_SORTID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPMX_SORTID	Character(10)	VARCHAR2(10) NOT NULL	SORT ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	GPMX_SEQ01	Character(4)	VARCHAR2(4) NOT NULL	Order 01 0010=Company 0020=Pay Group 0030=Pay Entity 0040=Location 0050=Department 0060=Supervisor Code 0070=Employee Type 0080=Employee ID 0090=Employee Name
7	GPMX_ASC_DESC01	Character(1)	VARCHAR2(1) NOT NULL	Ascending or Descending 01 Y/N Table Edit Default Value: N
8	GPMX_SEQ02	Character(4)	VARCHAR2(4) NOT NULL	Order 02 0010=Company 0020=Pay Group 0030=Pay Entity 0040=Location 0050=Department 0060=Supervisor Code 0070=Employee Type 0080=Employee ID 0090=Employee Name
9	GPMX_ASC_DESC02	Character(1)	VARCHAR2(1) NOT NULL	Ascending or Descending 02 Y/N Table Edit Default Value: N
10	GPMX_SEQ03	Character(4)	VARCHAR2(4) NOT NULL	Order 03 0010=Company 0020=Pay Group 0030=Pay Entity 0040=Location 0050=Department 0060=Supervisor Code 0070=Employee Type 0080=Employee ID 0090=Employee Name
11	GPMX_ASC_DESC03	Character(1)	VARCHAR2(1) NOT NULL	Ascending or Descending 03 Y/N Table Edit Default Value: N
12	GPMX_SEQ04	Character(4)	VARCHAR2(4) NOT NULL	Order 04 0010=Company 0020=Pay Group 0030=Pay Entity 0040=Location 0050=Department 0060=Supervisor Code 0070=Employee Type 0080=Employee ID 0090=Employee Name
13	GPMX_ASC_DESC04	Character(1)	VARCHAR2(1) NOT NULL	Ascending or Descending 04 Y/N Table Edit Default Value: N
14	GPMX_SEQ05	Character(4)	VARCHAR2(4) NOT NULL	Order 05 0010=Company 0020=Pay Group 0030=Pay Entity 0040=Location 0050=Department 0060=Supervisor Code 0070=Employee Type 0080=Employee ID 0090=Employee Name
15	GPMX_ASC_DESC05	Character(1)	VARCHAR2(1) NOT NULL	Ascending or Descending 05 Y/N Table Edit Default Value: N