List of New Data for PeopleSoft SIS
Data Elements Table Definitions
| Column | Definition |
|---|---|
| Adaptor Field | Field in the college adaptor |
| Adaptor Enum Values | If the field in the college adaptor has a specific list of values that it can have (known as an "enum" in Java), they are listed in this column |
| Online App Field | Field in the Online BOG Fee Waiver application that the adaptor field corresponds to |
| Staging/Audit Field | Field in the staging/audit table in PeopleSoft that the adaptor field is mapped to. A staging table is used so that a) there an audit trail of what data came in via the college adaptor and b) records that were not written because a record already existed |
| PeopleSoft Field | Field in PeopleSoft staging/audit table that adaptor field is mapped to. PeopleSoft fields are school-specific. |
Data Elements
| Adaptor Field | Adaptor Enum Values | Online App Field | Staging/Audit Field ps_cctc_bogfw_stg | PeopleSoft Field |
|---|---|---|---|---|
sisTermId^ | term_code | |||
| CCTC_MIS_CD | ||||
cccid | ccc_id | CCTC_CCCID | ||
| maritalStatus | S, M, D, X, W, R Where 'S' = Single, 'M' = Married, 'D' = Divorced, 'X' = Separated, 'W' = Widowed, and 'R' = Registered Domestic Partner | marital_status | MARITAL_STATUS | |
| regDomPartner | Y, N | reg_dom_partner | FT_ATTRIBUTE1 | |
| bornBefore23Year | Y, N | born_before_23_year | FT_ATTRIBUTE2 | |
| marriedOrRDP | Y, N | married_or_rdp | FT_ATTRIBUTE3 | |
| usVeteran | Y, N | us_veteran | FT_ATTRIBUTE4 | |
| dependents | Y, N | dependents | FT_ATTRIBUTE5 | |
| parentsDeceased | Y, N | parents_deceased | FT_ATTRIBUTE6 | |
| emancipatedMinor | Y, N | emancipated_minor | FT_ATTRIBUTE7 | |
| legalGuardianship | Y, N | legal_guardianship | FT_ATTRIBUTE8 | |
| homelessYouthSchool | Y, N | homeless_youth_school | FT_ATTRIBUTE9 | |
| homelessYouthHUD | Y, N | homeless_youth_hud | FT_ATTRIBUTE10 | |
| homelessYouthOther | Y, N | homeless_youth_other | FT_ATTRIBUTE11 | |
| dependentOnParentTaxes$ | Y, N | dependent_on_parent_taxes | FT_ATTRIBUTE12 | |
| livingWithParents | Y, N | living_with_parents | FT_ATTRIBUTE13 | |
| dependencyStatus* | D, I | dependency_status | FT_ATTRIBUTE14 | |
| certVeteranAffairs | Y, N | cert_veteran_affairs | FT_ATTRIBUTE15 | |
| certNationalGuard | Y, N | cert_national_guard | FT_ATTRIBUTE16 | |
| eligMedalHonor | Y, N | elig_medal_honor | FT_ATTRIBUTE17 | |
| eligSept11 | Y, N | elig_sept_11 | FT_ATTRIBUTE18 | |
| eligPoliceFire | Y, N | elig_police_fire | FT_ATTRIBUTE19 | |
| tanfCalworks | Y, N | tanf_calworks | FT_ATTRIBUTE20 | |
| ssiSSP | Y, N | ssi_ssp | FT_ATTRIBUTE21 | |
| generalAssistance | Y, N | general_assistance | FT_ATTRIBUTE22 | |
| parentsAssistance | Y, N | parents_assistance | FT_ATTRIBUTE23 | |
| depNumberHousehold | dep_number_household | NUM_DEPENDENTS | ||
| indNumberHousehold | ind_number_household | FAMILY_SIZE | ||
| depGrossIncome | dep_gross_income | F_GROSS_INCOME | ||
| indGrossIncome | ind_gross_income | STD_GROSS_INCOME | ||
| depOtherIncome | dep_other_income | F_OTHER_INCOME | ||
| indOtherIncome | ind_other_income | OTHER_INCOME | ||
| depTotalIncome | dep_total_income | TOTAL_INCOME_PAR | ||
| indTotalIncome | ind_total_income | TOTAL_INCOME_STU | ||
| eligibility | N, Y | elig_bogfw | ELIGIBLE_AID | |
| determinedResidentCA | Y, N | determined_residentca | FT_ATTRIBUTE24 | |
| determinedAB540Eligible | Y, N | determined_ab540_eligible | FT_ATTRIBUTE25 | |
| determinedNonResExempt | Y, N | determined_non_res_exempt | FT_ATTRIBUTE26 | |
| determinedHomeless | Y, N | determined_homeless | FT_ATTRIBUTE27 | |
| LASTUPDOPRID | ||||
| LASTUPDDTTM |
^ In PeopleSoft, BOGFW year can be school specific; some are yearly due to evaluating FAFSA, but that doesn't have to be the case.
- When a GET is performed, a term is supplied and will be returned with the result.
- When a POST is performed, the term supplied will dictate with FA Year to write the data to.
- On a GET or POST, if a term matches more than one FA Year, the configuration value FaExchangeBOGYearMatching will determine whether to use the first or last year (default is LAST).
i.e. STATUS = indicates a status of whether the import was successful.
- 1 = success
- 2 = fail