GPGB_LOAN_WA

(SQL Table)
Index Back

GP UK Loan Calc results WA

WA populated by GP Calculation. Contains Loan processed per Employees

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 GPGB_LOAN_ID Character(20) VARCHAR2(20) NOT NULL Unique ID for employee loans
9 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
10 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
11 PYMT_DT Date(10) DATE Payment Date
12 GPGB_TAX_END_YR Number(4,0) SMALLINT NOT NULL Tax Year Ends In This Calendar Year
13 GPGB_TAX_PERIOD Number(3,0) SMALLINT NOT NULL Tax Period
14 GPGB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Amount
15 GPGB_AMT_VAR Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Amount Variance
16 GPGB_AMT_EXCEP Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Amount Total
17 GPGB_AMT_TX_YR Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Amount for Tax Year
18 GPGB_AMT_TOT Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Amount Total
19 GPGB_AMT_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK - Balance Amount
20 END_DT Date(10) DATE end date