MULTYR_STDNT_VW(SQL View) |
Index Back |
|---|---|
Pay Plan Student View |
| select a.business_unit ,a.emplid ,a.contract_num ,a.tp_seq_nbr ,a.tp_status ,a.pre_plan_amt ,b.account_type_sf ,b.transfer_item_type ,b.credit_item_type ,b.tp_con_pay_credit ,b.interest_calc_mthd ,b.interest_rate ,b.interest_item_type ,b.monthcd ,b.day_of_month ,a.deficit_flg ,a.backdate_dt from PS_TP_STUDENT a, ps_tp_contract b where a.business_unit = b.business_unit and a.contract_num = b.contract_num and b.tp_con_type = 'M' |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH_SF |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table: MULTYR_CONT_VW |
| 4 | TP_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | TP Sequence Number |
| 5 | TP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Active C=Cancelled H=Hold I=Inactive U=Not Posted Default Value: A |
| 6 | PRE_PLAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Pre-Payment Plan Amount |
| 7 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 8 | TRANSFER_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Transfer Item Type |
| 9 | CREDIT_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Credit Item Type |
| 10 | TP_CON_PAY_CREDIT | Character(12) | VARCHAR2(12) NOT NULL | Payment Credit |
| 11 | INTEREST_CALC_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Interest Calculation Method
M=Calculated Monthly Y=Calculated Yearly |
| 12 | INTEREST_RATE | Number(16,6) | DECIMAL(15,6) NOT NULL | Interest Rate |
| 13 | INTEREST_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Interest Item Type |
| 14 | MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 15 | DAY_OF_MONTH | Number(2,0) | SMALLINT NOT NULL | Day of the Month |
| 16 | DEFICIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Deficit Flag |
| 17 | BACKDATE_DT | Date(10) | DATE | Back Date |