DEP_SCHED_ID_FRAEFFDTDefault Value: %date
DEBIT_DTA=Active
I=Inactive
Default Value: A
D=Day
M=Month
Q=Quarter
W=Week
Y=Year
Default Value: M
Default Value: %date
Default Value: %date
GPFR_DSN_DEP_SD(SQL Table) |
Index Back |
|---|---|
Stores Deposit ScheduleThis table is child table to store the deposit schedule details for the GP core component DEP_SCHED. As the existing DEP_SCHED component doesn't store the values of Frequency ,begin date ,start date & Days adjustment , it is required to have a record to store all the details for GPFRA specfic requirements. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEP_SCHED_ID_FRA |
Character(10) | VARCHAR2(10) NOT NULL | Deposit Schedule |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DEBIT_DT |
Date(10) | DATE | Debit Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DAY_UOM | Character(1) | VARCHAR2(1) NOT NULL |
Unit of Time in various increments of days (day being the lowest unit of measure). Used for schedule generation
D=Day M=Month Q=Quarter W=Week Y=Year Default Value: M |
| 6 | BGN_DT | Date(10) | DATE |
Begin Date
Default Value: %date |
| 7 | END_DT | Date(10) | DATE |
end date
Default Value: %date |
| 8 | DAYS_ADJUSTMENT | Signed Number(3,0) | DECIMAL(2) NOT NULL | Days Adjustment |