TERM_DEFLT_TBL(SQL Table) |
Index Back |
|---|---|
Business Unit Default Term Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: SF_TERM_VW2 |
| 5 | TERM_BEGIN_DT | Date(10) | DATE NOT NULL |
Term Begin Date
Default Value: %date |
| 6 | TERM_END_DT | Date(10) | DATE NOT NULL | Term Ending Date |
| 7 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
| 8 | ANTIC_AID_TRM_FROM | Character(4) | VARCHAR2(4) NOT NULL |
Antic Aid Term From
Prompt Table: SF_TERM_VW2 |
| 9 | ANTIC_AID_TERM_TO | Character(4) | VARCHAR2(4) NOT NULL |
Antic Aid Term To
Default Value: RUN_CNTL_PRTIVC.ANTIC_AID_TRM_FROM Prompt Table: SF_TERM_VW2 |