PA_SP_TRAN(SQL Table) |
Index Back |
|---|---|
Service Purchase Transactions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_BEN_PLAN_VW |
| 3 | SP_ID |
Number(11,0) | DECIMAL(11) NOT NULL | Service Purchase ID |
| 4 | TRANSACTION_DATE | Date(10) | DATE |
TRANSACTION_DATE
Default Value: %Date |
| 5 | COMPONENT_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Component Name
E=Employment Verification S=Service Purchase Default Value: S |
| 6 | SP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Service Purchase Status
Default Value: EST Prompt Table: PA_SP_STATUS |
| 7 | PRIOR_SP_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Prior Status |
| 8 | SP_STATUS_RESN | Character(3) | VARCHAR2(3) NOT NULL |
Status Reason
Prompt Table: PA_SP_STRESN_VW |
| 9 | CASE_IDENTIFIER | Character(20) | VARCHAR2(20) NOT NULL | Case Identifier |
| 10 | SP_GAP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Service Purchase Gap Type
G=Gaps in Service U=Unknown W=Withdrawn Contribution |
| 11 | APPROVAL_DT | Date(10) | DATE | Approval Date |
| 12 | SVC_PURCHASE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Service Purchase Type
Prompt Table: PA_SP_TYPE_DEFN |
| 13 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 14 | END_DT | Date(10) | DATE | end date |
| 15 | WITHDRAW_DT | Date(10) | DATE | Withdraw Date |
| 16 | WITHDRAW_AMT_PRE | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Withdrawal Amount |
| 17 | WITHDRAW_AMT_POST | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Withdrawn Amount Post-Tax |
| 18 | VERIF_ID | Number(3,0) | SMALLINT NOT NULL | Verification ID |
| 19 | ELIG_OVERRIDDEN | Character(1) | VARCHAR2(1) NOT NULL | Eligibility Status Overridden |
| 20 | FUNCTN_RESULT_NM | Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 21 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 22 | ESTIMATE_NBR | Number(2,0) | SMALLINT NOT NULL | Estimate Number |
| 23 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table: CUSTOMER |
| 24 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 25 | EA_BAL_ESTAB | Character(1) | VARCHAR2(1) NOT NULL | Empl Acct Balance Established |
| 26 | AR_MSGS_SENT | Character(1) | VARCHAR2(1) NOT NULL | Receivables Messages Sent |
| 27 | REFUND_PMTS | Character(1) | VARCHAR2(1) NOT NULL |
Refund Payments Y/N indicator
N=No Y=Yes Default Value: N |
| 28 | NO_COST | Character(1) | VARCHAR2(1) NOT NULL |
No Cost to Purchase
N=No Y=Yes Default Value: N |