FA_APP_SRC_TYP (SQL Table)	Index Back
FA Application Source Table FA Application Source Table shows the valid sources of application data used in the different FA functions such as budgeting and packaging.

FA_APP_SRC_TYP

(SQL Table)

FA Application Source Table

FA Application Source Table shows the valid sources of application data used in the different FA functions such as budgeting and packaging.

Parent record: AID_YEAR_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL

3 SOURCE_RANK_TYPE Character(1) VARCHAR2(1) NOT NULL Source Rank Type
B=Budgets
P=Packaging

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %Date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
3	SOURCE_RANK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Source Rank Type B=Budgets P=Packaging
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	TABLE_ID	Character(1)	VARCHAR2(1) NOT NULL	Child Table Key Default Value: 1