INSTITUTIONPrompt Table: INSTITUTION_TBL
SRVC_IND_CDPrompt Table:
SRVC_IND_CD_TBL
Set Control Field: INSTITUTION
EFFDTDefault Value: D
Default Value: B
Default Value: 9999
UPG_SCC_OLD_CD(SQL Table) |
Index Back |
|---|---|
Populate Service Ind CodePopulate Service Ind Code before Direct/Split Option. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | SRVC_IND_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table:
SRVC_IND_CD_TBL
|
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | UPG_DIRECT_SPLIT | Character(1) | VARCHAR2(1) NOT NULL |
Should the Service Indicator Code be direct or split
Default Value: D |
| 6 | UPG_BLANK_START | Character(1) | VARCHAR2(1) NOT NULL |
End term must be blank or equal to the start term
Default Value: B |
| 7 | UPG_CONVERT_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Convert '9999' to 0000 or 9999
Default Value: 9999 |
| 8 | HTMLAREA | Long Character | CLOB | HTML Area |