| reconsideration_request_id |
int8 |
19 |
|
|
null |
|
|
System generated sequence number to uniquely identify a RECONSIDERATION REQUEST |
| alr_application_id |
int8 |
19 |
|
|
null |
|
|
System generated sequence number to uniquely identify an ALR APPLICATION. This is also used as the ALR APPLICATION’S external reference number. |
| received_date |
timestamp |
29,6 |
|
|
null |
|
|
Date the requested was received by the ALC |
| new_information_ind |
varchar |
1 |
|
|
null |
|
|
Indicates whether or not new information is being provided for the Commission to consider. |
| error_information_ind |
varchar |
1 |
|
|
null |
|
|
Indicates whether or not the applicant has demonstrated there was error in the information the Commission had when the decision was rendered |
| new_proposal_ind |
varchar |
1 |
|
|
null |
|
|
Indicates whether or not the applicant is submitting a different proposal than the original application |
| staff_recommendation |
varchar |
3 |
√ |
|
null |
|
|
The recommendation ALC staff made to the Commission (yes, no, or no recommendation) |
| description |
varchar |
4000 |
√ |
|
null |
|
|
Further description of the RECONSIDERATION REQUEST |
| approved_date |
timestamp |
29,6 |
√ |
|
null |
|
|
The date the request was approved. |
| who_created |
varchar |
32 |
|
|
null |
|
|
WHO CREATED is the IDIR or Oracle userid of the person who created the record. |
