HR_CMP052JP_AET (SQL Table)	Index Back
State record for HR_CMP013 This record is used as the state record for the Application Program HR_CMP013.

HR_CMP052JP_AET

(SQL Table)

State record for HR_CMP013

This record is used as the state record for the Application Program HR_CMP013.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 SAL_INC_ID Character(12) VARCHAR2(12) NOT NULL Salary Increase ID

6 CALC_NUM Number(3,0) SMALLINT NOT NULL Calculation Number

7 SELECT_ALL Character(1) VARCHAR2(1) NOT NULL Select All
Y/N Table Edit
Default Value: N

8 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

9 CAL_BASE_DT Date(10) DATE Calculation As Of Date

10 SAL_INC_DT Date(10) DATE Salary Increase Date

11 EFF_DIGIT Character(2) VARCHAR2(2) NOT NULL Apply Rounding At
-1=1st Decimal
-2=2nd Decimal
-3=3rd Decimal
-4=4th Decimal
-5=5th Decimal
-6=6th Decimal
1=Units
2=Tens
3=Hundreds
4=Thousands

12 ROUNDING_RULEJ Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
H=Round
U=Round Up

13 MULTICURRENCY Character(1) VARCHAR2(1) NOT NULL Multi-Currency

14 EXIST Character(1) VARCHAR2(1) NOT NULL Currency Exist

15 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

16 EXCHNG_TO_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

17 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	SAL_INC_ID	Character(12)	VARCHAR2(12) NOT NULL	Salary Increase ID
6	CALC_NUM	Number(3,0)	SMALLINT NOT NULL	Calculation Number
7	SELECT_ALL	Character(1)	VARCHAR2(1) NOT NULL	Select All Y/N Table Edit Default Value: N
8	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
9	CAL_BASE_DT	Date(10)	DATE	Calculation As Of Date
10	SAL_INC_DT	Date(10)	DATE	Salary Increase Date
11	EFF_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Apply Rounding At -1=1st Decimal -2=2nd Decimal -3=3rd Decimal -4=4th Decimal -5=5th Decimal -6=6th Decimal 1=Units 2=Tens 3=Hundreds 4=Thousands
12	ROUNDING_RULEJ	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down H=Round U=Round Up
13	MULTICURRENCY	Character(1)	VARCHAR2(1) NOT NULL	Multi-Currency
14	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist
15	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
16	EXCHNG_TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
17	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.