Tuesday, September 28, 2010

NA Payroll Configuration Tables

Payroll Configuration Tables:

1. National ID Type
2. Name Suffix
3. Action
4. Action Reason
5. Banks
6. Form Table
7. Source Bank Accounts
8. Holiday Schedule

1. Earnings Table
2. Earnings Program Table
3. Special Accumulators Table
4. Review Special Accumulators

1. Deduction Table
2. General Deduction Table
3. Company General Deduction
4. Deduction Subset Table
5. Review Deduction Subsets

1. Pay Group
2. Balance ID
3. Pay Run ID
4. Pay Calendars
5. Create Pay Calendars
6. Pay Message Table
7. Paycheck options
8. Rapid Entry Pay sheet
9. Configuration Online Printing
10. Final Check Program
11. Final Check Action / Reason

U.S. Taxes:

1. Tax Location Code.
2. Federal/State Tax Table
3. Company State Tax
4. State Tax Reciprocity
5. SWT Marital Status
6. Taxable Gross Definition.
7. Local Tax Table
8. Company Local Tax Table
9. Local Tax Reciprocity Table
10. Work Locality Reciprocity

1. Disposable Earnings Definition
2. Disposable Earnings Defn – CAN
3. Rules Table
4. Rules Table – CAN
5. Proration Rules Definition
6. State Proration Rules
7. Clone Rules
8. Payee Table

1. Retroactive Pay Program
2. Retroactive Pay Mass Request

1. Reporting Unit Table
2. Business Information
3. Activity Table

Payroll for North America relies heavily on the information that is set up in the HRMS foundation tables, such as :
• SetID
• Location
• Frequency
Job Code

How To delete a process

Once a process is added (PeopleTools -> Process Scheduler -> Process) then it can be deleted from the following table.
5. PS_PRCSDEFNXFER ( Not required always)
6. PSPNLFIELD ( Not required always)

Department Security Tree

Always create a department security tree with the name "DEPT_SECURITY" as it is hardcoded in various views and very important in implementing Row level security. If this naming is not followed then departments under newly created tree will not be available while setting up the security on "Security by Dept Tree" page.

Monday, September 6, 2010

How can you Specify the Type and Size of File Attachments That Can Be Uploaded?

Use the Maxsize & Filetype option in the Addattachment function Call.

Syntax: AddAttachment(URLDestination, DirAndFilename, FileType, UserFile, MaxSize)

URLDestination - A reference to a URL. This can be either a URL name, in the form URL.URLName, or a string. This is where the file is transferred to.

DirAndFileName - A directory and filename. This is appended to the URLDestination to make up the full URL where the file is transferred to.
Note. The URLDestination requires "/" (forward) slashes. Because the DirAndFileName parameter is appended to the URL, it also requires only "/" slashes. "\" (backward) slashes are NOT supported in anyway for either the URLDestination or the DirAndFileName parameter.

FileType - A string to use as a suggestion for the extension file type, such as ".doc", ".gif", ".properties" and so on. Passing in a null string (that is, two double-quotes with no space ("")) will invoke all files (*.*)

UserFile - The name of the file on the source system.

MaxSize - Specify, in kilobytes, the maximum size of the attachment.

So, if you specify 100, that means the maximum size allowed is 100k.

The FileType parameter is only a suggestion. Specifying it does not enforce specific file types. If you do not want specific file types (such as .exe or .bat) you must write PeopleCode to discern the name and file type of the attached file and delete it.

When the end user views attachments using the ViewAttachment function, some browsers treat documents as HTML regardless of file extension, and thus execute embedded java script. You may want to write a PeopleCode program to only allow specific file extensions to be viewed.