INSTITUTIONSRVC_IND_CDEFFDTUPG_NEW_CDDefault Value: B
Default Value: 9999
UPG_SPL_CD(SQL Table) |
Index Back |
|---|---|
Upgrade the Split Codes.Upgrade the Split Codes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SRVC_IND_CD |
Character(3) | VARCHAR2(3) NOT NULL | Service Indicator Cd |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | UPG_NEW_CD |
Character(3) | VARCHAR2(3) NOT NULL | Split New Service Indicator Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |