ASGN_CMP_EFFDT (SQL Table)	Index Back
EE Assgn Compensation-Effdt ASGN_CMP_EFFDT is one of a group of records used to record information about an employee's job assignments away from home base. This data is part of the International Assignment application. ASGN_CMP_EFFDT is the parent record for compensation data related to an employee's international assignment.

ASGN_CMP_EFFDT

(SQL Table)

EE Assgn Compensation-Effdt

ASGN_CMP_EFFDT is one of a group of records used to record information about an employee's job assignments away from home base. This data is part of the International Assignment application. ASGN_CMP_EFFDT is the parent record for compensation data related to an employee's international assignment.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 PAY_INSTR_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Instruction Type
I=International Compensation
O=Onetime payment
Default Value: I

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 ASGN_COMP_FREQ Character(5) VARCHAR2(5) NOT NULL Amount Frequency
A=Annual
H=Hourly
M=Monthly
Default Value: A
Prompt Table: ASGN_FREQ_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	PAY_INSTR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Instruction Type I=International Compensation O=Onetime payment Default Value: I
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	ASGN_COMP_FREQ	Character(5)	VARCHAR2(5) NOT NULL	Amount Frequency A=Annual H=Hourly M=Monthly Default Value: A Prompt Table: ASGN_FREQ_VW