SETIDPrompt Table: SP_SETID_NONVW
INSTIDPrompt Table: GM_INSTITUTION
EFFDTDefault Value: %date
LOCATIONPrompt Table: LOCATION_TBL
Y/N Table Edit
Y/N Table Edit
GM_IN_ADDRESS(SQL Table) |
Index Back |
|---|---|
Institution Address |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | INSTID |
Character(5) | VARCHAR2(5) NOT NULL |
Institution ID
Prompt Table: GM_INSTITUTION |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 5 | PROPOSAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Location
Y/N Table Edit |
| 6 | BILL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Billing Location
Y/N Table Edit |
| 7 | AWARD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Award Location |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |