INSTALLATION_SA(SQL Table) |
Index Back |
|---|---|
Student Admin Install OptionsIf you use auto-numbering in PeopleSoft Student Administration, such as auto-assignment of employee IDs, you enter the beginning sequence number here. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID_LAST_CS | Number(10,0) | DECIMAL(10) NOT NULL | Last Organization ID Assigned |
| 2 | MAIN_RQRMNT_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Requirement ID |
| 3 | RQRMNT_GROUP_LAST | Number(6,0) | INTEGER NOT NULL | Last Requirement Group |
| 4 | RQ_SHARE_ID_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Course Sharing Sequence |
| 5 | RQ_PLN_SHR_ID_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Plan Sharing Sequence |
| 6 | COND_SPEC_LAST | Number(6,0) | INTEGER NOT NULL | Last Requirement Condition |
| 7 | COND_PROCID_LAST | Number(4,0) | SMALLINT NOT NULL | Last Condition Procedure |
| 8 | COURSE_LIST_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Course List Sequence |
| 9 | CRSE_ID_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Course ID Assigned |
| 10 | EQUIV_CRSE_ID_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Equiv Course ID Assigned |
| 11 | EXT_ORG_ID_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last External Organization ID |
| 12 | FACILITY_ID_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Facility ID Assigned |
| 13 | CLASS_NOTE_ID_LAST | Number(4,0) | SMALLINT NOT NULL | Last Class Note ID Assigned |
| 14 | ADM_APPL_NBR_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Application Nbr Assigned |
| 15 | TEST_REC_NBR_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Test Type Rec Nbr |
| 16 | ATP_REC_NBR_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last ATP Rec Nbr |
| 17 | TERM_WD_REQ_LAST | Number(12,0) | DECIMAL(12) NOT NULL | Last Term Withdrawal Request |
| 18 | RQ_AA_OVRD_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Advisement Override |
| 19 | RQ_ENT_GRP_LAST | Number(6,0) | INTEGER NOT NULL | Last Rqrmnt Entity Grp Nbr |
| 20 | FACILITY_CONFLICT | Character(1) | VARCHAR2(1) NOT NULL |
Status of Facility
Y/N Table Edit Default Value: Y |
| 21 | EXT_SA_EVENT_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last External SA Event ID |
| 22 | ENRL_TGT_SEQ_LAST | Number(7,0) | INTEGER NOT NULL | Enrollment Target Sequence Number |
| 23 | CRS_TOPIC_LNK_LAST | Number(7,0) | INTEGER NOT NULL | Last Topic Link Assigned |
| 24 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 25 | DEFAULT_SECT_SIZE | Number(3,0) | SMALLINT NOT NULL | Default Section Size |
| 26 | TRANSCIPT_DT_PRT | Character(2) | VARCHAR2(2) NOT NULL |
Transcript Date Print
C=Print Class Dates N=Do Not Print Any Dates S=Print Session Dates T=Print Term Dates |
| 27 | SSR_CLSRSLT_MAX | Number(9,0) | DECIMAL(9) NOT NULL | Max. Class Search Results |
| 28 | SSR_CLSRSLT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Class Search Result Option
E=Error Message - limit search W=Warning Message Default Value: W |
| 29 | SSR_CLSRCH_SUBJOPT | Character(2) | VARCHAR2(2) NOT NULL |
Class Search Subject Option
10=Drop-Down List Box 20=Prompt Search Default Value: 10 |
| 30 | SSR_GPA_DEC_IND | Character(2) | VARCHAR2(2) NOT NULL |
GPA Decimal rouding or truncating flag
R0=Round to 0 decimal place R1=Round to 1 decimal place R2=Round to 2 decimal places R3=Round to 3 decimal places T0=Truncate to 0 decimal place T1=Truncate to 1 decimal place T2=Truncate to 2 decimal places T3=Truncate to 3 decimal places Default Value: R3 |
| 31 | SAA_HOW_USED_AA | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to control how academic advisement is used at the installation level
A=Academic Advisement N=Not in Use P=Program Guide Default Value: A |
| 32 | SCC_CRM_INSTALL | Character(1) | VARCHAR2(1) NOT NULL |
CRM for Higher Education
Y/N Table Edit Default Value: N |
| 33 | SSR_RS_CANDIT_NBR | Character(12) | VARCHAR2(12) NOT NULL | Candidate Number |
| 34 | SSR_RS_CAN_CNSMPTN | Character(1) | VARCHAR2(1) NOT NULL |
Research Enrollment Tracking candidate days or term trigger to be used in the calculation of consumption.
D=Day T=Term |