PA_CLC_SVC_ADJ

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Default Value: PA_EACCT_TRANS.BENEFIT_PLAN

2 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name

Default Value: PA_EACCT_TRANS.FUNCTN_RESULT_NM

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: PA_EACCT_TRANS.EMPLID

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: PA_EACCT_TRANS.SEQNUM

5 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

Default Value: PA_EACCT_TRANS.TRANSACTION_DATE

6 DATE_FROM Date(10) DATE Date From
7 DATE_TO Date(10) DATE Previous Period Date To
8 PA_SVC_DURATN Signed Number(17,6) DECIMAL(15,6) NOT NULL Duration Result