GPIN_EXEM_TMP

(SQL Table)
Index Back

Exemption Tax Record - India

Exemption Tax Record - India

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD7

4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
5 BGN_DT Date(10) DATE Begin Date
6 BGN_DT_BFR Date(10) DATE Begin Date
7 END_DT Date(10) DATE end date
8 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.