ACCOUNT_TERM_VW(SQL View) |
Index Back |
---|---|
Student Account Term View |
select business_unit, emplid, account_nbr, account_term from PS_ACCOUNT_SF |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SF_NONVW |
|
2 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
|
3 | Character(10) | VARCHAR2(10) NOT NULL | Account Nbr | |
4 | Character(4) | VARCHAR2(4) NOT NULL | Account Term |