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 |