EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTPrompt Table: SAD_LAW_CD
SEQ_NOY/N Table Edit
Default Value: N
SAD_LAW_CD_REC(SQL Table) |
Index Back |
|---|---|
LSAC Suspense Recommend InfoThis contains the LSDAS Recommendation Information stored in this 'live' table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | TEST_DT |
Date(10) | DATE NOT NULL |
Test Date
Prompt Table: SAD_LAW_CD |
| 3 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | LSAC_REC_NBR | Character(12) | VARCHAR2(12) NOT NULL | Recommender Number |
| 5 | LSAC_REC_NAME | Character(100) | VARCHAR2(100) NOT NULL | Recommender Name |
| 6 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 8 | SAD_ADDRESS3_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 9 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 10 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 11 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 12 | LSAC_REC_ENT_DT | Character(10) | VARCHAR2(10) NOT NULL | Letter Entry Date |
| 13 | LSAC_REC_SENT_DT | Character(10) | VARCHAR2(10) NOT NULL | LSAC Acknowledgement Letter Date |
| 14 | LSAC_REC_SIG | Character(1) | VARCHAR2(1) NOT NULL |
Signature Received
Y/N Table Edit Default Value: N |
| 15 | REC_FOR_ADD_LSDAS | Character(30) | VARCHAR2(30) NOT NULL | LSDAS Recommender Foreign Address |
| 16 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |