SFA_PU_INSF_TRG(SQL Table) |
Index Back |
---|---|
Bind for Population UpdateThis table hosts required fields for multiple records for Population Update. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
3 | BUDGET_DURATION_A | Number(2,0) | SMALLINT NOT NULL | Budget Duration - Acad Per |
4 | BUDGET_DURATION_N | Number(2,0) | SMALLINT NOT NULL | Budget Duration - Non-Std |
5 | CALC_PC_FOR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Calc a PC for Independent
Y/N Table Edit |
6 | FM_EFC_PRORTN_ACAD | Character(1) | VARCHAR2(1) NOT NULL |
Academic Proration Method
1=Use Monthly EFCs 2=Adjust Based on Total EFC 3=Proportion Monthly Share |
7 | FM_EFC_PRORTN_NSTD | Character(1) | VARCHAR2(1) NOT NULL |
Non-Standard Proration Method
1=Leading Months 2=Trailing Months 3=FA Term Based |
8 | INAS_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calc Type
B=Both FM & IM F=Federal Methodology I=Institutional Methodology |
9 | INAS_DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Data Source
B=Both Federal & Institutional F=Federal Data I=Institutional Data |
10 | INAS_RULE_SET | Character(4) | VARCHAR2(4) NOT NULL |
Option Rule Set
BASE=CSS Rules/Values HLTH=Health Professional STD=Undergrad/Graduate |