Control Tables Keyed by Tableset ID

Here are some examples of the control tables keyed by tableset ID for each application in Campus Solutions. This information can help you decide how the data can be segmented, so that you make the correct decisions when setting up the tableset IDs and assign the correct tableset IDs to record groups.

Note:

This list is not exhaustive.

This table lists some examples of control tables keyed by tableset ID:

PeopleSoft Application	Control Tables Keyed by Tableset ID
PeopleSoft Student Records	FACILITY_TBL - Facility LOCATION_TBL - Location GRADESCHEME_TBL - Grading Schemes LVL_LD_RULE_TBL - Level/Load Rules PROG_RSN_TBL - Program Action Reasons REPEAT_SCHM_TBL - Repeat Schemes TIME_PERIOD_TBL - Time Periods UNIT_CONVR_TBL - Unit Conversions
PeopleSoft Student Financials	ACCT_TYP_TBL_SF - Account Types ACC_AGE_FEE_TBL - Aging Late Fee table ACC_AGING_TBL - Account Aging table ADJ_CODE_TBL - Adjustment Code table ADJ_REASON_TBL - Adjustment Reason table ADJ_TERM_CD_TBL - Adjustment Term Code table ADJ_TERM_TBL - Adjustment Term table AGING_CAT_TBL - Aging Category table AGING_TBL - Aging table APP_FEE_CD_TBL - App Fee Code table APP_FEE_TBL - Application Fee table APP_FEE_TND_TBL - App Fee Tender and Item Types APP_SF_CD_TBL - App Sub-Fee Code table APP_SUBFEE_TBL - App Sub Fee table BANK_ACCT_MTHD - Bank Account Payment Method BI_ACCT_STD_REQ - Accounts for Std Req BI_ACDPROG_STAT - Std Req Academic Prog Status BI_ADMPROG_STAT - Std Req Admissions Prog Status BI_BILL_MSG_TBL - Billing Msg table for SF BI_CAR_STD_REQ - Career for Std Req BI_COM_STD_REQ - Communication Std. Request BI_IVC_FIELDS - Billing Invoice Field table BI_IVC_LAYOUT - Billing Invoice Layout BI_MSG_CAT_TBL - Billing Message Cat table BI_PRINT_RQST - Billing Standard Print Request BI_REQ_MSG - Billing Request Message BI_STD_REQ_GRP - Billing Student Groups BI_STD_REQ_TBL - Billing Standard Request table BI_TERM_STD_REQ - Terms for Std Req BI_TYPE_TBL - Billing Type table BNK_RCN_INP_LAY - Bank Recon Input File Layout
PeopleSoft Student Financials (cont.)	BNK_RCN_INP_TRN - Bank Transaction Code CALC_CNTL_SESS - Tuition Calc Control Sessions CALC_CNTL_TBL - Tuition Calculation Controls CALC_CNTL_TERM - Tuition Calc Control Terms CALC_ON_REFUND - Calc on Refund Control CLASS_FEE_TBL - Class Fee table CLASS_SBFEE_TBL - Class Sub Fee table CLST_FEE_TBL - Course Fee table CLST_SUBFEE_TBL - Course Sub Fee table CLS_CANCEL_SF - Class Cancellation Code table COLL_LTRITM_TBL - Collection Letter Item table COLL_LTRTMP_TBL - Collection Letter Template table CO_VOID_RSN_TBL - Void Reasons CREDIT_CARD_TYP - Credit Card Type CRSE_FEE_ID_TBL - Course Fee ID table CRSE_FEE_TBL - Course Fee table CRSE_LST_DTL_SF - Course List Detail CRSE_LST_HDR_SF - Course List Header CRSE_RATE_TBL - Course Rate table CRSE_RT_ID_TBL - Course Rate ID table CRSE_SUBFEE_TBL - Course Sub Fee table DEP_DUE_DT_TBL - Deposit Date table DEP_FEE_CD_TBL - Deposit Fee Code table DEP_FEE_TBL - Deposit Fee table DEP_FEE_TRM_TBL - Deposit Fee Term table DISP_ERR_CNTL - Display Error/Warn Control DUE_CODE_TBL - Due Date Code table DUE_DATE_CD_TBL - Due Date Code table DUE_DATE_TBL - Due Date table
PeopleSoft Student Financials (cont.)	EG_PROJECT - E&G Operational Projects FEE_CLASS_TBL - Fee Class table FEE_TBL - Fee table FINCODE_TBL - FinCode table GL_INTERFACE - General Ledger Interface GL_INT_CD_TBL - General Ledger Dummy Parent GL_INT_DT_TBL - General Ledger Dummy Parent II GROUP_TYPE_SF - Group Type GROUP_TYPE_TBL - Group Type ITEM_ACCT_TYPE - Valid Account Types ITEM_AGG_TBL - Item Aggregate table ITEM_FA_CD_TBL - Item Type Code table ITEM_GROUP_DTL - Item Type Group Details ITEM_GROUP_TBL - Item Type Group table ITEM_TYPE_1_TBL - Item Type Control table ITEM_TYPE_FISCL - Fiscal Item Type table ITEM_TYPE_FNOTE - Fiscal Item Type Notes table ITEM_TYPE_TBL - Item Type table JRNLGEN_DEFN - Journal Generator Definition LATE_FEE_AGING - Late Fee Aging Category table LATE_FEE_CD_TBL - Late Fee Code table LATE_FEE_LOAD - Late Fee Acad Program table LATE_FEE_PROG - Late Fee Acad Program table LATE_FEE_SCHEME - Late Fee Scheme table LATE_FEE_TBL - Late Fee Setup table LED_FLDS_SF_TBL - ChartFields LED_FLDS_TBL - ChartFields LED_SF_TBL - ChartFields Parent Rec LINE_REASON_TBL - Line Reason table
PeopleSoft Student Financials (cont.)	MAX_FEE_ADM_TRM - Max fee for Admit Term MIN_MAX_FEE - Min/Max fee table MIN_MAX_FEE_CAR - Min/Max fee for Acad Career MIN_MAX_FEE_PGM - Min/Max Fee for Acad Program MIN_MAX_FEE_SES - Min/Max Fee for Session MIN_MAX_FEE_TRM - Min/Max Fee for Term MIN_MAX_FEE_YR - Min/Max Fee for Academic Year OPT_FEE_CAR - Optional Fee Careers OPT_FEE_CD_TBL - Optional Fee Codes table OPT_FEE_TBL - Optional Fees table OPT_FEE_TERM - Optional Fee Terms OPT_FEE_TRM_EF - Optional Fee Effdts for a Term OPT_FEE_TRM_LD - Optional Fee Academic Loads OPT_FEE_TRM_VAL - Optional Fee Values for a Term OPT_FEE_VAL - Optional Fee Values ORIGIN_TBL - Group & Deposit Origins PAY_PRIOR_ALL - Payment Priority Overall PMT_CHRG_PRIOR - Payment Charge Priority PMT_CHRG_TBL - Payment Charge Priority table REASON_IN_TBL - SF Reason In REASON_OUT_TBL - SF Reason Out SEC_ITEM_CLS - Item Security - Perm List SEC_ITEM_OPR - Item Security - User Data SEC_SETID_CLS - User ID Access to SetIDs SEC_SETID_OPR - User ID Access to SetID SEL_VALID_FIELD - Selector Group Valid Fields SEL_VALID_RECS - Selector Group Valid Records SEL_VALUE_OLD - Selector Values table SF_ACCT_CLASS - SF Account Class SPEEDTYP_TBL - Speed Types SPEED_USER_TBL - Work Table for Speed Types
PeopleSoft Student Financials (cont.)	TAX_AUTHORITY - Tax Authority Detail Info TAX_AUTH_HDR - Tax Authority Header Info TAX_CD - Tax Authorities in a Tax Code TAX_HEADER_TBL - Tax Code Header Information TERM_FEE_RES - Term Fee Resident table TERM_FEE_TBL - Term Fee table TERM_FE_CD_TBL - Term Fee Code table TERM_SF_CD_TBL - Term Sub Fee Code table TERM_SUBFEE_TBL - Term Sub Fee table TP_STATUS_TBL - Third-party Contract Status TRANS_FEE_HDR - Transaction Fees Header TRANS_FEE_TBL - Transaction Fees TRANS_FE_CD_TBL - Transaction Fee Codes VALID_RECORD_SF - Valid Records for Selectors VENDOR_SF_TBL - SF to Vendor interface table WAIVER_CODE_TBL - Waiver Code table WAIVER_FORM_TBL - Student Waivers WAIVER_GRP_DTL - Waiver Group Detail table WAIVER_GRP_TBL - Waiver Group table WAIVER_TBL - Waiver table WVR_GRP_CD_TBL - Waiver Group Code table
PeopleSoft Recruiting and Admissions	PSTREEDEFN - PeopleTools table used in the creation of the Region Tree
PeopleSoft Financial Aid	AWD_MESSAGE_TBL - Award Messages/Comments BDGT_REGION_TBL - Budget Region table ITEM_TP_FA_DISB - Item Type Disb Plan/Split Cd ITEM_TYPE_FA - Item Type Table SFAG ITEM_TYP_FA_FEE - Item Type Fee table ITM_TP_TERM_LMT - Award Limits by Term Type LN_FEE_TBL - Loan Fee table LN_ITEM_FEE - Loan Item Type Fee table LN_ITEM_TBL - Loan Item Type table RSTRC_AID_ITEM - Restricted Aid IDs/Item Type
PeopleSoft Contributor Relations	AV_ACCOUNT_TBL - Designation Funds AV_INST_TYP_TBL - Designation Types AV_ITEM_TBL - Donor Appreciation Items AV_MBR_CAT_TBL - Membership Categories AV_MBR_TYP_TBL - Membership Types AV_MTVTN_INTV - Appeals linked to Initiative Codes AV_MTVTN_TBL - Appeal Codes AV_ORIG_DNR_TBL - Original Donors to Designation Funds AV_TENDER_TBL - Tender Types AV_TRIB_TBL - Tributes on Designation Funds