Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO NO NO
|
NO
|
MIF_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
'N' N
|
NO NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
SOLICITOR_IND
|
Indicates if staff person is a solicitor.
|
VARCHAR2(1)
|
AMRSTAF CONSTANT
|
AMRSTAF_SOLICIT_IND 'N'
|
NO NO
|
NO
|
STAFF_ASSIGNMENT_END_DATE
|
|
DATE
|
|
|
|
NO
|
STAFF_ASSIGNMENT_START_DATE
|
|
DATE
|
|
|
|
NO
|
STAFF_ASSIGNMENT_STATUS_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
STAFF_IDEN
|
Staff identification code.
|
VARCHAR2(5)
|
AMBPROP AMRCONT AMRSTAF
|
AMBPROP_STAFF_IDEN_CODE AMRCONT_IDEN_CODE AMRSTAF_IDEN_CODE
|
NO NO NO
|
NO
|
STAFF_IDEN_NAME
|
Name of the person with primary responsibility for this prospect.
|
VARCHAR2(30)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
STAFF_TYPE
|
Staff type code.
|
VARCHAR2(4)
|
AMRSTAF
|
AMRSTAF_STFT_CODE
|
NO
|
NO
|
STAFF_TYPE_DESC
|
Staff type description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STAFF_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
AMBPROP AMRSTAF GOBEACC
|
AMBPROP_STAFF_PIDM AMRSTAF_STAFF_PIDM GOBEACC_PIDM
|
NO NO NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|