BUSINESS_UNITREFUND_NBRLINE_SEQ_NBRPrompt Table: PEOPLE_SRCH
C=Complete
E=Entered
P=Posted
X=Cancelled
C=Charge
P=Payment/Financial Aid
A=Automatic Check
C=Credit Card
D=Direct Deposit
E=Electronic Check
P=Paper Check
REFUND_DTL(SQL Table) |
Index Back |
|---|---|
Refund Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REFUND_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
| 3 | LINE_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr |
| 4 | LINE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Line Amount |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 6 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 7 | REFUND_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Refund ID |
| 8 | ITEM_NBR | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
| 9 | REFUND_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Refund Line Status
C=Complete E=Entered P=Posted X=Cancelled |
| 10 | REFUND_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Refund Line Type
C=Charge P=Payment/Financial Aid |
| 11 | REFUND_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Refund Format
A=Automatic Check C=Credit Card D=Direct Deposit E=Electronic Check P=Paper Check |
| 12 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 13 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |