PKG_EXP_CMP_TBL

(SQL Table)
Index Back

Pkg Expense Component Tbl

Salary Packaging - Expense Component Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE NOT NULL Effective Date
4 ASOFDATE Date(10) DATE As of Date
5 COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal package - Package Component

Prompt Table: PKG_BSE_CMP_TBL

6 BSE_COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal Package - Base Component
7 COMPONENT_AMT_TPV Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Pacakge - TPV Component Amount
8 COMPONENT_AMT_TEC Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - TEC Component Amount
9 ACTUAL_AMT_TEC Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Actual TEC
10 ACTUAL_AMT_TPV Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Actual TPV
11 PROJ_AMT_TPV Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Projected YTD Amount TPV
12 PROJ_AMT_TEC Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal pacakge - Projected YTD Expenditure TEC
13 ADDITIONAL_FLAG Character(1) VARCHAR2(1) NOT NULL Sal Package - Additional Flag

Y/N Table Edit

14 OVERBUDGET_FLAG Character(1) VARCHAR2(1) NOT NULL Sal Package - Over Budget Indicating Flag

Y/N Table Edit