RUN_CNTL_SF_LFE(SQL Table) |
Index Back |
|---|---|
Run Control- Billing Late Fees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BATCH_ID | Character(12) | VARCHAR2(12) NOT NULL | Batch ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT |
| 5 | BI_REQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Billing Request Nbr
Prompt Table: BI_HDR_LATE_VW |
| 6 | REPORT_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Report Only
N=Final Y=Review Default Value: N |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: BI_LATE_EMP_VW |
| 8 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: BI_LATE_ORG_VW |
| 9 | SSF_PYMT_DATE_FROM | Date(10) | DATE | Payment Date From |
| 10 | SSF_PYMT_DATE_TO | Date(10) | DATE |
Payment Date To
Default Value: %date |
| 11 | SSF_LATE_MAX_FROM | Date(10) | DATE | Late Fee Maximum From |
| 12 | SSF_LATE_MAX_TO | Date(10) | DATE |
Late Fee Maximum To
Default Value: %date |
| 13 | INCLUDE_AA | Character(1) | VARCHAR2(1) NOT NULL |
Include Anticipated Aid?
Default Value: N |
| 14 | SSF_MAX_AID_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Maximum Aid Term
Prompt Table: TERM_VAL_TBL |
| 15 | SSF_LATE_FEE_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Late Fee Code
Prompt Table:
SSF_LATE_FEE_CD
|
| 16 | SSF_POST_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Posting Term
Prompt Table: TERM_VAL_TBL |