EMPLIDPrompt Table: STUDENT_AID
DL_PNOTE_IDPNOTE_ACTN_SEQPNOTE_MSG_SEQDefault Value: P
LN_DL_PNOTE_MSG(SQL Table) |
Index Back |
|---|---|
Loan Prom Note MsgThis record tracks the Promissory Note(s) associated with each Loan Origination record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
| 2 | DL_PNOTE_ID |
Character(21) | VARCHAR2(21) NOT NULL | DL Pnote Unique ID |
| 3 | PNOTE_ACTN_SEQ |
Number(3,0) | SMALLINT NOT NULL | Promissory Note Action Seq |
| 4 | PNOTE_MSG_SEQ |
Number(2,0) | SMALLINT NOT NULL | Promissory Note Msg Seq |
| 5 | LN_ACTION_MSG | Character(4) | VARCHAR2(4) NOT NULL | Message Code |
| 6 | LN_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Loan Action Type
Default Value: P |