WCS_ECM_TRN_HST

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DATE_POSTED Date(10) DATE Date Posted
2 WCS_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Type
AWD=VC Award Update
SAL=Salary Update
3 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
4 BUDGET_START_DT Date(10) DATE Budget Period Start Date
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
8 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
9 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
10 WCS_TRANS_STATUS Character(3) VARCHAR2(3) NOT NULL Transaction Status
LDE=Load Error
PND=Pending
PRC=Processed
PUB=Published