| Data element |
Definition |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | unique identifier for org (non-individual) records |
"
SRVC_IND_DTTM
Indexed - No
Format - DATE
Nullable - N | The date and time the record was created or updated. |
"
OPRID
Indexed - No
Format - VARCHAR2
Nullable - N | Id of the staff who entered the data. |
"
INSTITUTION
Indexed - Yes
Format - VARCHAR2
Nullable - N | Always UPENN |
"
SRVC_IND_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Service indicator code. |
"
SRVC_IND_REASON
Indexed - Yes
Format - VARCHAR2
Nullable - N | Code indicating the reason for the service indicator. |
"
SRVC_IND_ACT_TERM
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not used. |
"
SRVC_IND_ACTIVE_DT
Indexed - No
Format - DATE
Nullable - N | Start of the indicator. |
"
POS_SRVC_INDICATOR
Indexed - No
Format - VARCHAR2
Nullable - N | Yes/No field indicating a positive or negative service indiator. |
"
SRVC_IND_REFRNCE
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
DEPTID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Always UPENN. |
"
POSITION_NBR
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not used. |
"
CONTACT
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
CONTACT_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not used. |
"
CURRENCY_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Country code for currency (most often USD) |
"
AMOUNT
Indexed - No
Format - NUMBER
Nullable - N | Not used. |
"
CHECKLIST_DTTM
Indexed - No
Format - DATE
Nullable - Y | Not used. |
"
PLACED_METHOD
Indexed - No
Format - VARCHAR2
Nullable - N | Indicates how the indicator was created. Almost always B-batch. |
"
PLACED_PERSON
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
PLACED_PERSON_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not used. |
"
PLACED_PROCESS
Indexed - Yes
Format - VARCHAR2
Nullable - N | Indicates the batch program that created the indicator. |
"
RELEASE_PROCESS
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not used. |
"
COMM_COMMENTS
Indexed - No
Format - VARCHAR2
Nullable - Y | Not used. |
"
