| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACTIVE_STAFF_ASSIGNMENT_IND
|
Indicates if the staff assignment is active based upon its status and if the system date is between the start and end date of the staff assignment.
|
CHAR(1)
|
CALCULATION
|
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND
|
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
CONTACT_STAFF_IND
|
Determines if the staff person has been responsible for a prospect management related contact with the prospect. (Y)es, the staff person has been responsible for a contact, (N)o, the staff person has not been responsible for a contact.
|
VARCHAR2(1)
|
FUNCTION
|
AOKODSF.F_GET_STAFF_INDICATOR
|
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
AMBPROP AMRCONT AMRSTAF
|
AMBPROP_PIDM AMRCONT_PIDM AMRSTAF_PIDM
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PLAN_MANAGER_IND
|
Determines if this staff person has ever been assigned a strategy plan for the prospect. (Y)es the staff person has been a plan manager, (N)o the staff person has not been a plan manager.
|
VARCHAR2(1)
|
FUNCTION
|
AOKODSF.F_GET_STAFF_INDICATOR
|
|
PRIMARY_IND
|
Determines if this staff person is the current primary staff assignment to the prospect. (Y)es, this is the current primary staff assigned, (N)o, this is not the current primary staff assigned.
|
VARCHAR2(1)
|
AMRSTAF CONSTANT
|
AMRSTAF_PRIMARY_IND 'N'
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROPOSAL_STAFF_IND
|
Determines if this staff person has ever been assigned to a proposal for this prospect. (Y)es the staff person has been assigned to a proposal, (N)o the staff person has never been assigned to a proposal.
|
VARCHAR2(1)
|
FUNCTION
|
AOKODSF.F_GET_STAFF_INDICATOR
|
|
PROSPECT_STAFF_IND
|
Determines if the staff person exists as a direct assignment to the prospect. (Y)es, the staff person is directly assigned to the prosect, (N)o, the staff person is not directly assigned to the prospect.
|
VARCHAR2(1)
|
FUNCTION
|
AOKODSF.F_GET_STAFF_INDICATOR
|
|
SOLICITOR_IND
|
Indicates if staff person is a solicitor.
|
VARCHAR2(1)
|
AMRSTAF CONSTANT
|
AMRSTAF_SOLICIT_IND 'N'
|
|
STAFF_ASSIGNMENT_END_DATE
|
Staff assignment end date.
|
DATE
|
CALCULATION
|
NVL(AMRSTAF_END_DATE,'31-DEC-2099')
|
|
STAFF_ASSIGNMENT_START_DATE
|
Staff assignment start date.
|
DATE
|
AMRSTAF
|
AMRSTAF_START_DATE
|
|
STAFF_ASSIGNMENT_STATUS_IND
|
Indicates if the staff assignment is (1) acitve or (0) inactive.
|
VARCHAR2(1)
|
AMRSTAF
|
AMRSTAF_STATUS_IND
|
|
STAFF_ASSIGN_STATUS_IND_DESC
|
Staff assignment status description.
|
VARCHAR2(255)
|
AMRSTAF
|
AMRSTAF_STATUS_IND
|
|
STAFF_IDEN
|
Staff identification code.
|
VARCHAR2(63)
|
AMBPROP AMRCONT AMRSTAF
|
AMBPROP_STAFF_IDEN_CODE AMRCONT_IDEN_CODE AMRSTAF_IDEN_CODE
|
|
STAFF_IDEN_NAME
|
Name of the person with primary responsibility for this prospect.
|
VARCHAR2(255)
|
GURIDEN
|
GURIDEN_DESC
|
|
STAFF_TYPE
|
Staff type code.
|
VARCHAR2(63)
|
AMRSTAF
|
AMRSTAF_STFT_CODE
|
|
STAFF_TYPE_DESC
|
Staff type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STAFF_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
AMBPROP AMRSTAF GOBEACC
|
AMBPROP_STAFF_PIDM AMRSTAF_STAFF_PIDM GOBEACC_PIDM
|