AMT05_JPN_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
5 JOB_EFFDT Date(10) DATE Job Effective Date
6 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 SALINC_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount of Salary Increase