| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REPORT_DUE_DATE |
Date(10) |
DATE |
Report Due Date
|
| 4 |
RPT_TOTALS_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Totals Only
Y/N Table Edit
Default Value: N
|
| 5 |
REPORT_PROBATNARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Probationary Employees
Y/N Table Edit
Default Value: N
|
| 6 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 7 |
REPORTING_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Medium
C=Cartridge
D=Diskette
T=Tape
X=Electronic
Default Value: D
|
| 8 |
DISKETTE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Diskette Type
0=Not Applicable
1=3.5 Inches High Density
2=3.5 Inches Double Density
Default Value: 1
|
| 9 |
REMITTER_NUMBER |
Number(6,0) |
INTEGER NOT NULL |
Remitter Number
|
| 10 |
CONTACT_PERSON |
Character(30) |
VARCHAR2(30) NOT NULL |
Contact Person
|
| 11 |
CONTACT_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Contact Phone
|
| 12 |
TEC_SUFFIX |
Character(5) |
VARCHAR2(5) NOT NULL |
TEC Suffix Code
|
| 13 |
RETURN_NAME |
Character(44) |
VARCHAR2(44) NOT NULL |
Return Name
|
| 14 |
RETURN_STREET |
Character(35) |
VARCHAR2(35) NOT NULL |
Return Street
|
| 15 |
RETURN_CITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Return City
|
| 16 |
RETURN_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Return State
Prompt Table:
STATE_NAMES_VW
|
| 17 |
RETURN_ZIP |
Character(10) |
VARCHAR2(10) NOT NULL |
Return Zip
|
| 18 |
MAXIMUM_WEEKS |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Weeks
|
| 19 |
TAPE_AUTH_NUMBER |
Number(4,0) |
SMALLINT NOT NULL |
Tape Authorization Number
|
| 20 |
NJ_STATE_MINIMUM |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
State Minimum Wages
|
| 21 |
CONTACT_PHONE_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Contact Phone Extension
|
| 22 |
CONTACT_SIG_TITLE |
Character(40) |
VARCHAR2(40) NOT NULL |
Contact Person's Title
|
| 23 |
PROGRAM_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Mode
R=Report Only
U=Update
Default Value: R
|
| 24 |
CURRENT_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Table Entries Only
Y/N Table Edit
Default Value: Y
|
| 25 |
REPORT_COUNTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Country
B=Both Canada and US
C=Canada
U=USA
Default Value: B
|
| 26 |
CANADA_FORM_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Form Type
A=T4A Footnotes Only
ART=All
R=RL-1 Footnotes Only
Default Value: ART
|
| 27 |
WAGE_RPT_CHECK_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Wage Report Check Amt
|
| 28 |
PROVIDERID |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider ID
|
| 29 |
REIMBURSABLE_ER |
Character(1) |
VARCHAR2(1) NOT NULL |
Reimbursable Employer
Y/N Table Edit
Default Value: N
|
| 30 |
TAXFORM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Option
A=All Tax Form IDs
S=Selected Tax Form IDs
Default Value: A
|
| 31 |
CONTACT_NAME_SSA |
Character(27) |
VARCHAR2(27) NOT NULL |
Name of the Person to be contacted by SSA.
|
| 32 |
TELEPHONE_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Telephone Number
|
| 33 |
PHONE_EXTN |
Number(5,0) |
INTEGER NOT NULL |
Telephone Extension.
|
| 34 |
CONTACT_FAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Contact FAX Number.
|
| 35 |
EMAIL_ADDR_MMREF |
Character(40) |
VARCHAR2(40) NOT NULL |
Email Address for MMREF
|
| 36 |
THIRD_PARTY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Third Party Administrator ID
|
| 37 |
PY_FILE_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Stores the file format to report the data to the corresponding revenue office.
A=Fewer Than 15,000 Employees
C=CSV Format
E=Employer Submission
G=15,000 Or More Employees
I=ICESA Format
M=More Than One Company Per File
O=One Company Per File
T=Agent Submission
|