FSDEMO fresh- 28sep2004 | | FSTRAIN gold- 10sep2012
db- eis303L | | db- eis106L
app- isserv304 | | app- isserv102
web- isserv303 port- 8004 | | web- isserv101 port- 8008
nt- | | nt- reports-train \\psreport2-dev T:
- ufinsi8 \\dms-testsrv2 N: | | - ufinsi8 \\dms-testsrv2 N:
_|_ _|_
| |
FSDEVL fresh- 01sep2012 | FSQA fresh- 01sep2012 | PSFN
db- eis303L | db- eis104L | db- eis208L
app- isserv304 port- 8100 3tier | app- isserv102 port- 8300 3tier | app- isserv216 port- 8400 3tier
web- isserv303 port- 8006 | web- isserv101 port- 8010 | web- isserv215 port- 8012
nt- reports-devl \\psreport2-dev R: | nt- reports-qa \\psreport2-dev Q: | nt- reports-psfn \\psreport2 W:
- ufinsi8 \\dms-testsrv2 N: | - ufinsi8 \\dms-testsrv2 N: | - psoft \\ntserve1 U:
_|_ _|_
| |
| | FSPRDCPY fresh- Wednesday
| | db- eis106L
| | app- isserv102 port- 8600 3tier
| | web- isserv101 port- 8014
db- ufinDW84, ufinLA01, ufinDC01 | | nt- reports-pcpy \\psreport2-dev V:
app- ufin84, (fsdevl fsqa psfn) | | - ufi8nsi8 \\dms-testsrv2 N:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _|_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _|
| PSAGENT1
schema- psysadm | os- windows NT DOS
oracle- 10g rel:10.2.0.5.0 64bi [asof- 19feb2011 | nt- scripts \\psagent1 D:
client- 11.2.0.1.0 Admin -on MS 7 64bi |
module- Financials/SCM 8.40.02.000 (AP GL/PO) [asof- 15may2004 TimeOut:2hr | check machine
tools- 8.47.16 [asof- 12jul2008 | os- windows VISTA
l.box- Dell PowerEdge R710 |
s.box- Sun Fire V240 |_
l.os- Red Hat 4.1.2-50 Kernel- 2.6.32-300.21.1.el5uek |
s.os- SunOS 5.9 , 9/05 , 122300-63 |
IE- 8 |
Excel- Microsoft Office Professional plus 2010 |
web- Oracle BEA WebLogic 8.1 sp-6 |
app- Oracle BEA Tuxedo 8.1 rp-135 |
ldap- Sun One Directory Server, LDAP(5).PRINCETON.EDU port- 389 |
sqr- for PeopleSoft v8.47.16 |
cobol- Micro Focus Server Express V4.0 revision 000 Compiler |
crystal- CR9 Crystal Reports 9.2.3.884 |
_|_
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
GL Journal Feeds: TWS_streams & times & feeder. Notes: Mon-Fri, no-triggers, data files: *.prn, paperless
J:\\dms-smbserve\psdrop\psxfr\Maestro\psfn\*.lis ->[ psagent1 ]->
K:\\files\dept\Treasurers Office\Financial Reporting\Automatic feed journals only\*.lis
FNS8GLJV4 4:30 Am dc la ae gb pl mi fa hr fr ts cs m2 m3 m4 m5 gf lr ei ep cn
FNS8GLJV2 10:00 Am dc la ae gb pl mi fa hr fr ts cs m2 m3 m4 m5 gf lr ei ep cn
FNS8GLJV5 10:30 Am thu 2:45 Pm la
FNS8GLJV 3:00 Pm dc la ae gb pl mi fa hr fr ts cs m2 m3 m4 m5 gf lr ei ep cn
FNS8GLJV6 3:15 Pm thu 7:00 Pm la
FNS8GLJV3 7:30 Pm dc la ae gb pl mi fa hr fr ts cs m2 m3 m4 m5 gf lr ei ep cn
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
AP Voucher Feeds: TWS_streams & times & triggers & files & share-names. Notes: Mon-Fri Batch Checks: Mon & Fri
FNS8LIB 4:00 Pm fnjlib1_fnslib_signal lib_vchr.dat libvouchers
FNS8AE 4:07 Pm fnjae1_aepmnt1_signal ae_vchr.dat
FNS8DS 4:14 Pm fnjds1_fnsds_signal ds_vchr.dat dsvouchers
FNS8TG 4:21 Pm fnjtg1_fnstg_signal tg_vchr.dat tuition
FNS8LS 4:28 Pm fnjls1_fnsls_signal ls_vchr.dat garnish
FNS8PPL 4:35 Pm ppl_voucher_signal ppl_vchr.dat
FNS8LR 4:42 Pm fnjlr1_fnslr_signal lr_vchr.dat
FNS8RTP 4:49 Pm rtp_vchr.dat
FNS8PR 4:56 Pm fnjpr1_fnspr_signal pr_vchr.dat
FNS8ECM 5:03 Pm fnjecm1_fnsecm_signal ecm_vchr.dat ecmvouchers [ ecmvchrtest ]
FNS8CNR 5:10 Pm fnjcnr1_fnscnr_signal cnr_vchr.dat
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
server: aissmb224l (aka: aissmb224l,dms-smbserve,isserv224,tango)
\\dms-smbserve\[ Share ]
Share: ufin-drop -> /dmsdrop/psoft/psdrop/usr/[ NetId ]
: ufin-budget -> /dmsdrop/psoft/budget_journals/
: ufin-chkrec -> /dmsdrop/psoft/pnc_checkrec/
: ufin-checks -> /dmsdrop/psoft/ap_checks/
: ufin-test-drop -> /dmsdrop/psoft/ps75/
: ufin-image-key -> /dmsdrop/psoft/image_keys/[ PO , RTP , CHK ]
: ppl-VendorAdds -> /dmsdrop/psoft/ppl_vendor_adds/[ vendorAdds_IN , vendorAdds_OUT ]
: psdrop -> /dmsdrop/psoft/psdrop/
: dsvouchers -> /dmsdrop/psoft/ds_vouchers/
: garnish -> /dmsdrop/psoft/ls_vouchers/
: libvouchers -> /dmsdrop/psoft/lib_vouchers/
: ecmvouchers -> /dmsdrop/psoft/ecm_vouchers/
: tuition -> /dmsdrop/psoft/tg_vouchers/
: frglprod -> /dmsdrop/psoft/fr_journals/
: gbglprod -> /dmsdrop/psoft/gb_journals/
: hrglprod -> /dmsdrop/psoft/hr_journals/
: lrglprod -> /dmsdrop/psoft/ls_journals/
: tsglprod -> /dmsdrop/psoft/ts_journals/
: epESTMjrnls -> /dmsdrop/psoft/ep_ESTMjrnls/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
--LA InterFace
/dmsdrop/LA/Datain
--CC InterFace
/dmsdrop/campcomd/prod_files
--HR InterFace
/dmsdrop/pshrsa76/bn_interfaces/tuition_checks/prod
--IW Triggers
/dmsdrop/dadepot/
--UNIX AppServer
/var/local/bin/*fax*
/var/local/bin/*gpg*
/bin/*ftp*
--Work
/dmsdrop/psoft/psdrop/usr/[ NETID ] 115 sub-directories
/dmsdrop/psoft/psdrop/
/dmsdrop/psoft/psdrop/psxfr/
/dmsdrop/psoft/psdrop/glarea/
/dmsdrop/psoft/psdrop/psxfr/Maestro/psfn/ GL paperless
/dmsdrop/psoft/ps75/ test-area
--GL
/dmsdrop/psoft/[ SYSTEM ]_journals/ 20 sub-directories
/dmsdrop/psoft/budget_journals/
/dmsdrop/psoft/bd_journals/Bjournals/
/dmsdrop/psoft/cs_journals/Bjournals/
/dmsdrop/psoft/fc_journals/Bjournals/
/dmsdrop/psoft/cs_project_grants/
/dmsdrop/psoft/fr_project_grants/
--AP
/dmsdrop/psoft/[ SYSTEM ]_vouchers/ 11 sub-directories
/dmsdrop/psoft/ap_pos_pay/
/dmsdrop/psoft/pnc_checkrec/
/dmsdrop/psoft/ap_checks/
--PO
/dmsdrop/psoft/image_keys/PO/
/dmsdrop/psoft/image_keys/RTP/
--ORPA
/dmsdrop/psoft/orpa_monthly/
--Web Splash Page
/dmsdrop/psoft/web/
--TWS Tracking
/dmsdrop/psoft/maestro_history/ *DBLINKS* *MLOG*
/dmsdrop/psoft/maestro_duration/
/dmsdrop/psoft/maestro_error/
/dmsdrop/psoft/maestro_iface/
--Test Drop Area
/dmsdrop/psoft/ps75/la_journals/prdcpy/
/dmsdrop/psoft/ps75/*
--Documentation
p:\IS Prod Control\Transition\U Fin\Programmers Notes\*
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
E-mail Address Sources:
Links.. SYN_CC_FIN_HEADER_TBL, SYN_PS_BANK_BRANCH_TBL
SYN_CC_TO_AP_ID_VIEW , SYN_CDD_CONTACT_INFORMATION
TWS.. FNJ8APHRPRINT , FNJ8CDDADDCHGRPT
Tables.. PS_PU_DEPT_CONTACT
AppEngine.. BATCH pu-batch-pg-suspense-email PU_SUSPENSE1
/psoft/ufin84/maestro/mail/.. mail.scr, ALERT-mail.scr
/psoft/ufin84/maestro/loads/.. gl_LAjrnl_funnel_out.ksh, gl_jrnl_funnel_out.ksh, gl_jrnl_funnel_in.ksh
gl_budg_funnel_out.ksh , gl_proj_funnel_out.ksh, pu_signal_check.scr
report_count.scr , *vouch*.scr , *vchr*.scr
runctl-pu-batch-pg-suspense-email.sh
/psoft/ufin84/iface/.. appospay_checkreccount.ksh , appospay_currentdate.sh , appospay_diddatechange.ksh
runctl-pu-batch-pg-suspense-email.sh , GL_to_LA_org.sh , D-seed.awk
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Sources for printer: xenewsouth2fl
TWS.. FNS811PO FNJ8PODIS & FNJ8PODIS2 , FNS815PO FNJ8PODIS & FNJ8PODIS2
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
- - - - - - - - - - - - - - - Partial graph of core TWS Schedules. For complete scope: TWS - - - - - - - - - - - -
FNS8PON Start @ 6:00 Pm
FNS8EII-CREATE Start @ 6:00 Pm
(create EII ACUTAL journal flat file)
FNS8APGLN Start @ 6:30 Pm
FNS8GLPG Start @ 7:00 Pm
FNS8GLBJ Start @ 7:30 Pm ---> FNS8GLJV3 Start @ 7:30 Pm
(load BUDGET journal flat file) (load ACUTAL journals flat file)
|
-
|
FNS8GLACOE
(Edit/Post Coeus ACTUALS journals)
|
-----------------------------------------
| |
FNS8GLBCOE FNS8GLAEII
(Edit/Post Coeus BUDGET journals) (Edit/Post EII ACTUALS journals)
FNS8GLRPTX Start @ 8:00 Pm
.
--------------------------------
| | |
FNJ8GLRPTX9 FNJ8GLRPTX44 FNJ8GLRPTX8
zgls0947.sqr zgls0944.sqr zgls0948.sqr
open_enc_po climb_tree pend_exp
| | |
--------------------------------
|
NULL1
|
------------------------------------------------
| | | |
FNJ8GLRPTX2 FNJ8GLRPTX7 FNJ8GLRPTX11 FNJ8GLRPTX1
zgls0952.sqt zgls0957.sqr zgls0959.sqr zgls0951.sqr
journals cap_bdln burden_total rptg_ledger
| | | |
------------------------------------------------
|
NULL2
|
----------------
| |
FNJ8GLRPTX6 FNJ8GLRPTX4
zgls0956.sqr zgls0954.sqr
cap_jrnl summ_ledger
| | |
---------------- -----------------------
| | |
FNJ8GLRPTX3 FNJ8GLRPTX10 FNJ8GLRPTX12
zgls0953.sqr zgls0931.sqr zgls0932.sqr
spr rf_image & rf_info rf_esmt
|
-
|
FNJ8GLRPTX5
zgls0955.sqr
cap_bud
FNS8DWE1 Start @ 9:01 Pm
FNS8LADWE1 Start @ 9:02 Pm
FNS8DCDWE1 Start @ 9:03 Pm
FNS8EII-BACKFILL Start @ 1:00 Am
Lock Box- eis207L email: LB-list =get /dmsdrop/u/lbadmin/
/dmsdrop/lrtrans1/lockbox/
LBSDAILY_W_GPG Start @ 12:59 Pm Until 3:36 Pm
.
LBJ8-SCHED-START
|
LBJSTART touch LB_NOT_THERE_YET; rm LB_IS_THERE; (triggers)
|
LBJGET {ftp =get} Start @ 1:00 Pm .. Iterate Every 15 Minutes .. Until 3:00 Pm
| &
| LB_NOT_THERE_YET (trigger). If GET finds data: touch LB_IS_THERE;
| rm LB_NOT_THERE_YET;
------------------------------------------------
| |
LBJNOTFOUND Start @ 3:35 Pm LBJRTRANS {gpg}
& LB_NOT_THERE_YET (trigger) & LB_IS_THERE (trigger)
|
LBJEDIT
|
LBJEXTRACT
|
LBJREPORT
|
LBJFINISH - rm LB_NOT_THERE_YET LB_IS_THERE;
|
LBJ8-SCHED-STOP
Positive Pay- eis208L email: tech-list =put
FNS8APPOSPAY Start @ 2:00 Pm Unitl 3:00 Pm
.
FNJAPPOSPAY1
|
FNJAPPOSPAY2
|
FNJAPPOSPAY3
|
FNJAPPOSPAY4 {gpg} {ftp =put}
AP Check Reconciliation Feed: isserv216 TWS_stream & time & file. Notes: Mon-Fri, no-trigger =get
FNS8CHKREC Start 9:00 Am
.
FNJ8CHKREC_FTP_GET {gpg} {ftp =get}
|
FNJ8CHKREC00AA
|
FNJ8CHKREC01PNC
|
FNJ8CHKREC99ZZ
FNS8GLRPTX FNS8DWE1 LBSDAILY_W_GPG
(isserv216) (eis208l) (eis207l)
. . .
FNJ8-SCHED-START --o FNJ8-SCHED-START --o LBJ8-SCHED-START --o
* | * | * |
(stack Of jobs) | (stack of jobs) | (stack of jobs) |
* | * | * |
o-- FNJ8-SCHED-STOP | FNJ8-SCHED-STOP | o-- LBJ8-SCHED-STOP |
| | | | |
| | | | |
| o-------------------( -----------------------( -o |
| | | | | /dmsdrop/psoft/maestro_duration/
| | | | |
| | | | o---> PROD.LBSDAILY_W_GPG <--o|
| | | o----------------------------> FSDWPROD.FNS8DWE1 <--o|
| | 0-----------------------------------------------------> PSFN.FNS8GLRPTX <--0|
| | |
| | FNS8-SCHED-CHECK |
| | (isserv216) |
| | . |
| | FNJ8-SCHED-CHECK Start 1:00Pm, Iterate Every 15 Minutes, Until 1:00Am <----------------o
| | |
| | |
| | o-- ALERT Email --o
| | |
| | | /dmsdrop/psoft/maestro_error/
| | |
| | o---------> FSDWPROD.FNS8DWE1
| |
| |
| | /dmsdrop/psoft/maestro_history/
| |
| o--------------------------------------------------------------------------> PROD.LBSDAILY_W_GPG
o----------------------------------------------------------------------------> PSFN.FNS8GLRPTX
Updated: Tue Mar 26 16:13:01 EDT 2013