EMPLIDPrompt Table: PERS_SRCH_GBL
BENEFIT_PLANPrompt Table: PA_BEN_PLAN_VW
SP_IDESTIMATE_NBRSEQUENCE_NBRDefault Value: 1
INSTALL_NBRPA_SP_TRAN_INST(SQL Table) |
Index Back |
|---|---|
SP Trans Pmt Installment |
| # | 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 | ESTIMATE_NBR |
Number(2,0) | SMALLINT NOT NULL | Estimate Number |
| 5 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 6 | INSTALL_NBR |
Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |
| 7 | DUE_DATE | Date(10) | DATE | Due Date |