3C Configuration - Administrative Functions

Understanding Administrative Functions

When setting up a new comment, checklist or communication, you will need to select an administrative function.  The administrative functions are tied to variable data in the system, which links to specific fields of information that can be used as a part of the communication.  The chart below shows the available Administrative Functions and the variable data fields connected to them. Queries used in the batch assign process require a Bind Record included as a part of the query.  Also listed below is the query bind record for each administrative function and the fields required in the query.  

Code
Administrative Function Variable Data Fields Query Bind Record Query Fields (Key fields in Bold)
ADMA Admissions Application

[Application Level]
Academic Career
Student Career Number
Application Number
SCC_PS_ADMA_BND EMPLID
ACAD_CAREER
ADM_APPL_NBR
INSTITUTION

NAME
ADMP Admissions Program
[Program Level]
Academic Career
Student Career Number
Application Number
Application Program Number
SCC_PS_ADMP_BND EMPLID
ACAD_CAREER
STDNT_CAR_NBR
ADM_APPL_NBR
INSTITUTION
APPL_PROG_NBR

NAME
AVAK Advancement Acknowledgements Designation Code
Gift Number
Initiative Code
Recognition Type
Session Number
SCC_PS_AVAK_BND BUSINESS_UNIT
SESSION_NO
GIFT_NO
RECOGNITION_TYPE
DESIGNATION
INTV_CD
EMPLID
EXT_ORG_ID
INSTITUTION
AVIN Advancement Initiatives Audience Code
Audience Type
Initiative Code
SCC_PS_AVIN_BND INSTITUTION
EMPLID
EXT_ORG_ID
AV_AUDIENCE
AUD_TYPE
INTV_CD
AVMB
AVMS
Advancement Membership Benefits
Advancement Membership
Member Payment Number
Standard Benefit
Membership Number
Membership Organization Code
No Bind Record for Advancement Membership Benefits

SCC_PS_AVMS_BND
(for Advancement Membership)
BUSINESS_UNIT
EMPLID
EXT_ORG_ID
AV_MBR-ORG-COD
MEMBERSHIP_NBR
INSTITUTION
AWRD Awarding Academic Career
Aid Year
Item Type
SCC_PS_AWRD_BND EMPLID
AID_YEAR
ITEM_TYPE
ACAD_CAREER
INSTITUTION

NAME
BDGT Budget Maintenance Academic Career
Aid Year
Effective Date (FINA)
Term
No Bind Record
EVNT Event Event ID
Meeting Number (optional)
SCC_PS_EVNT_BND EMPLID
CAMPUS_EVENT_NBR
EVENT-MTG-NBR
INSTITUTION

NAME
FINA Financial Aid Aid Year SCC_PS_FINA_BND EMPLID
AID_YEAR
INSTITUTION

NAME
FINT Financial Aid Term Aid Year
Term
SCC_PS_FINT_BND EMPLID
AID_YEAR

STRM
INSTITUTION

NAME
GEN General None SCC_PS_GENP_BND EMPLID
INSTITUTION
NAME
IHC International Health Coverage Coverage Number SCC_PS_IHC_BND BUSINESS_UNIT
EMPLID
SSF_IHC_COVER_NBR
INSTITUTION

NAME
ISIR ISIR Corrections Aid Year
Effective Date (FINA)
Effective Sequence (FINA)
SCC_PS_ISIR_BND EMPLID
INSTITUTION
AID_YEAR
EFFDT
EFFSEQ

NAME
LOAN Loan Aid Year
Loan Type Code
Application Sequence
SCC_PS_LOAN_BND EMPLID
INSTITUTION
AID_YEAR
ACAD_CAREER
LOAN_TYPE
LN_APPL_SEQ
LN_APPL_ID

NAME
NLBP Internships NLD Internal Contract SCC_PS_NLBP_BND EMPLID
SAD_INT_CONTR_NLD
INSTITUTION

NAME
NLOW Educational Contracts NLD Contract Number SCC_PS_NLOW_BND EMPLID
SAD_INT_CONTR_NLD
INSTITUTION

NAME
PROP Prospect Program Academic Career
Academic Program
Recruiting Center
SCC_PS_PRP_BND EMPLID
ACAD_CAREER
ACAD_PROG
INSTITUTION

NAME
PROS Prospect Academic Career SCC_PS_PROS_BND EMPLID
ACAD_CAREER
INSTITUTION

NAME
PSSV Prospect Self Service Academic Career SCC_PS_PSSV_BND EMPLID
ACAD_CAREER
INSTITUTION

NAME
RECR Recruiters Academic Career SCC_PS_RECR_BND EMPLID
ACAD_CAREER
INSTITUTION

NAME
RSTR Restricted Aid Aid Year
Restricted Aid ID
SCC_PS_RSTR_BND EMPLID
INSTITUTION
AID_YEAR
RESTRICTED_AID_ID

NAME
SENR Student Enrollment Academic Career
Class Number
Academic Term
SCC_PS_SENR_BND EMPLID
ACAD_CAREER
STRM
CLASS_NBR
INSTITUTION

NAME
SFAC Student Financials Account Business Unit
Account Number
Account Term
SCC_PS_SFACO_BN BUSINESS_UNIT
EXT_ORG_ID
ACCOUNT_NBR
ACCOUNT_TERM
INSTITUTION
NAME



SCC_PS_SFACP_BN BUSINESS _UNIT
EMPLID
ACCOUNT_NBR
ACCOUNT_TERM
INSTITUTION

NAME
SFBI Student Financials Billing Business Unit
Invoice ID
SCC_PS_SFBI_BND EMPLID
EXT_ORG_ID
BUSINESS_UNIT
IONVOICE_ID
INSTITUTION
SFCO Student Financials Collections Business Unit
Collection ID
SCC_PS_SFCO_BND BUSINESS UNIT
COLLECTION_ID
EMPLID
EXT_ORG_ID
INSTITUTION
SFGR Student Financials Groups Business Unit
Group ID
No Bind Record
SFIT Student Financials Item Lines Business Unit
Item Number
Line Sequence Number
SCC_PS_SFIT_BND BUSINESS_UNIT
SA_ID_TYPE
COMMON_ID
ITEM_NBR
LINE_SEQ_NBR
INSTITUTION
SFPA Student Financials Payments Business Unit
Payment ID Number
SCC_PS_SFPA_BND BUSINESS _UNIT
SA_ID_TYPE
COMMON_ID
PAYMENT_ID_NBR
INSTITUTION
SFPR Student Financials Promise Checklist Date Time No Bind Record
SFRC Student Financials Receipt Business Unit
Cashier's Office
Receipt Number
SCC_PS_SFRC_BND BUSINESS_UNIT
CASHIER_OFFICE
RECEIPT_NBR
EMPLID
EXT_ORG_ID
SFTP Student Financials Contracts Business Unit
Contract Number
SCC_PS_SFTPO_BN BUSINESS_UNIT
CONTRACT_NU
INSTITUTION
EMPLID

NAME



SCC_PS_SFTPP_BN BUSINESS _UNIT
CONTRACT_NU
INSTITUTION
EMPLID

NAME
SPRG Student Program Academic Career
Career Number
SCC_PS_SPRG_BND EMPLID
ACAD_CAREER
STDNT_CAR_NBR
INSTITUTION

NAME
STRM Student Term Academic Career
Academic Term
SCC_PS_STRM_BND EMPLID
ACAD_CAREER
STRM
INSTITUTION

NAME

0 Comments

Add your comment

E-Mail me when someone replies to this comment