EMPLIDDL_PNOTE_IDA=Accepted
C=Closed
E=Endorser
I=Inactive
R=Rejected
X=Pending
HP=HEALTH PROFESSIONAL
MM=MPN
PK=PERKINS
PP=PNOTE
UU=UNIVERSITY
Y/N Table Edit
Y/N Table Edit
B=Batch
O=Authorize
P=Pending
LN_DL_PNOTE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DL_PNOTE_ID |
Character(21) | VARCHAR2(21) NOT NULL | DL Pnote Unique ID |
| 3 | LN_PNOTE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Loan Pnote Status
A=Accepted C=Closed E=Endorser I=Inactive R=Rejected X=Pending |
| 4 | LN_PNOTE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Loan PNOTE Type
HP=HEALTH PROFESSIONAL MM=MPN PK=PERKINS PP=PNOTE UU=UNIVERSITY |
| 5 | PNOTE_AMT | Number(5,0) | INTEGER NOT NULL | Promissory Note Amount |
| 6 | LN_PNOTE_SIGNED | Character(1) | VARCHAR2(1) NOT NULL |
Borrower Signature
Y/N Table Edit |
| 7 | PNOTE_SGNTR_DT | Date(10) | DATE | Promissory Note Signature Dt |
| 8 | LN_STU_SIGNTR | Character(1) | VARCHAR2(1) NOT NULL |
Student Signature
Y/N Table Edit |
| 9 | LN_STU_SIG_DT | Date(10) | DATE | Student Signature Date |
| 10 | LN_MANIFEST_SW | Character(1) | VARCHAR2(1) NOT NULL |
Loan Manifest Switch
B=Batch O=Authorize P=Pending |
| 11 | LN_MANIFEST_DT | Date(10) | DATE | Loan Manifest Date |