| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
HCR_PERSON_I
|
| 2 |
SSF_IHC_COVER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Coverage Number
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
SSF_IHC_PROVIDER |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider ID
Prompt Table:
SSF_IHC_PROVIDR
|
| 7 |
SSF_IHC_COVER_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Coverage Plan
Prompt Table:
SSF_IHC_PROVCVR
|
| 8 |
SSF_IHC_LNTH_COVER |
Number(2,0) |
SMALLINT NOT NULL |
Months of Coverage
Prompt Table:
SSF_IHC_PROVRAT
|
| 9 |
SSF_IHC_PREM_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
Premium Amount
|
| 10 |
SSF_IHC_PRMAMT_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Premium Amount Currencty Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
|
| 11 |
SSF_IHC_MEMBR_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Provider Member Number
|
| 12 |
SSF_IHC_BATCH_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Batch Number
|
| 13 |
SSF_IHC_START_DATE |
Date(10) |
DATE |
Coverage Start Date
|
| 14 |
SSF_IHC_EXPIRE_DT |
Date(10) |
DATE |
Coverage End Date
Default Value: SSF_IHC_EXPDTVW.EXPIRATN_DT
|
| 15 |
SSF_IHC_PAID_DIR |
Character(1) |
VARCHAR2(1) NOT NULL |
Provider Paid Directly
Y/N Table Edit
Default Value: N
|
| 16 |
SSF_IHC_COVER_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Coverage Type
CCDN=Change of Coverage - Decrease
CCUP=Change of Coverage - Increase
CNCL=Coverage Cancelled
NEWC=New Coverage
RNWL=Renewal
Default Value: NEWC
|
| 17 |
SSF_IHC_CNCL_REASN |
Character(3) |
VARCHAR2(3) NOT NULL |
Cancellation Reason
DIF=Death in Family
DNA=Student Did Not Arrive
ERR=User Error
VER=Visa Extension Rejected
VRC=Visa Re-Classification
|
| 18 |
ITEM_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Nbr
|
| 19 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
SF_TERM_VW
|
| 20 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 21 |
ITEM_EFFECTIVE_DT |
Date(10) |
DATE |
Item Effective Date
Default Value: %date
|
| 22 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 23 |
SSF_IHC_POSTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
N=No
Y=Yes
Default Value: N
|
| 24 |
SSF_IHC_POSTED_AMT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Posted Amount
|
| 25 |
SSF_IHC_PSTAMT_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Post Amount Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
|
| 26 |
SSF_IHC_POSTED_DT |
Date(10) |
DATE |
Post Date
|
| 27 |
SSF_IHC_RUN_DATE |
Date(10) |
DATE |
Run Date
|
| 28 |
SSF_IHC_RPT_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Number
|
| 29 |
SSF_IHC_SCHED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Type
C=Continuing Coverage Schedule
N=New Coverage Schedule
R=Refund Schedule
|
| 30 |
SSF_IHC_RPT_AMT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Reported Amount
|
| 31 |
SSF_IHC_RPTAMT_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Report Amount Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
|
| 32 |
SSF_IHC_RPT_AMTTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Amount Type
D=Report Difference
F=Report Full Amount
|
| 33 |
SSF_IHC_PRV_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Previously Reported on a Sched
|
| 34 |
SSF_IHC_PRVRPT_AMT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Previously Reported Amount
|